yearweek() result back to date format?

) | +---++ | 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 2003-11-15 above)? I'm using server v3.23. -- Trevor Smith|[EMAIL

how to upgrade / dependencies problem

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]

start / end dates for each week of year?

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] -- MySQL General Mailing List For list archives

quick PHP question

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://lists.mysql.com/mysql

Re: select by weekly SUM

), 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 weekly sums? -- Trevor Smith

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

-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]

maintaining delivery order in a table

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.mysql.com/mysql To unsubscribe

Re: maintaining delivery order in a table

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 better idea either. :-) -- Trevor Smith