how to upgrade / dependencies problem

roblem with any existing MySQL apps since I do very little to tax the server. -- Trevor Smith|[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

yearweek() result back to date format?

ot;2003-11-12") | yearweek("2003-11-12") | +---++ | Wednesday | 200346 | +---++ 1 row in set (0.00 sec) to extract the start and end dates for that week (for example, "2003-11-09" and &

start / end dates for each week of year?

ry day in every week in my table. Therefore there might be no data entered until Wednesday of any given week. So the first date with data entered for a given week is variable and adding 7 days to it would not produce a predictable or desirable result. -- Trevor Smith|[EMAIL PROTECTED]

quick PHP question

ny useful PHP function similar to MySQL's sec_to_time() or time_to_sec(). Nor can I make mktime() do anything useful here. Does anyone know of any PHP function that will solve my above need? -- Trevor Smith|[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lis

Re: select by weekly SUM

IMAL(5,2), no_of_deliveries TINYINT(1) UNSIGNED, total_tips DECIMAL(5,2), gas_used TINYINT(1) UNSIGNED, notes TEXT There is no "week" field. So, I have to compute 'week" by adding together sum(tips) for 7 consecutive days. Any suggestions how I can extract many consecutive week

select by weekly SUM

5: sum of tips for that week I can do them one week per query (obviously) but would like one query that will spit them all out, one after the other. -- Trevor Smith|[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Using LIKE to search for occurence of a column value in a string

e in NeedleColumn, if that's what you were looking for. I'm jumping in mid-stream so excuse me if I'm confused. -- Trevor Smith|[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: maintaining delivery order in a table

thing) but it would be unwieldy if the database changed often so I thought there might be some better idea. Rather than start it off inefficiently, I wanted to "do it right". Oh well. On the up side, I'm not as imagination-challenged as I thought--if no one else can think of a bette

maintaining delivery order in a table

s also not what I prefer. I'm looking for a simple, mysql-only solution that can store the delivery order in the table and that can be updated easily. Any suggestions? -- Trevor Smith|[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mys