Re: sort by date
| From: | eoghan | Date: | Fri, 06 May 2005 10:07:26 +0000 |
| Subject: | Re: sort by date | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-214610@lists.php.net to get a copy of this message | ||
William Stokes wrote:
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?something like; select my_date as STR_TO_DATE(date)...