Re: sort by date
| From: | William Stokes | Date: | Fri, 06 May 2005 08:17:05 +0000 |
| Subject: | Re: sort by date | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-214605@lists.php.net to get a copy of this message | ||
OK. I found that out from MySQL manual. I just don't know how to insert the
date formatting function to the query:
I quessI need to put STR_TO_DATE() in to the following SQL query:
SELECT event_id,name,date,time,place,type,info FROM test_table
WHERE (group = '$group') AND (type = 'Game' OR type = 'training')
ORDER BY date ASC
I dont know how?
Thanks a lot
-Will