Re: sort by date
| From: | Petar Nedyalkov | Date: | Fri, 06 May 2005 09:47:31 +0000 |
| Subject: | Re: sort by date | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-214609@lists.php.net to get a copy of this message | ||
On Friday 06 May 2005 11:17, 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:
What about DATE_FORMAT()?
>
> 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
--
Cyberly yours,
Petar Nedyalkov
Devoted Orbitel Fan :-)
PGP ID: 7AE45436
PGP Public Key: http://bu.orbitel.bg/pgp/bu.asc
PGP Fingerprint: 7923 8D52 B145 02E8 6F63 8BDA 2D3F 7C0B 7AE4 5436
Attachment: [application/pgp-signature]
Attachment: [application/pgp-signature]