RE: [PHP-DB] Select news based on dates

use the date functions in your mysql query, read the mysql manual for it. you can also just select * from a table and group it by date so all news articles on the same date will be displayed together. Perhaps you shouls also read up about groups in SQl. hope this helps angelo -----Original Message----- From: T. H. Grejc [mailto:php@1203.qwe.uni.cc] Sent: Monday, May 17, 2004 1:50 PM To: php-db@lists.php.net Subject: [PHP-DB] Select news based on dates Hello, I would like to display my news like this: *10.04.2004.* - news 1 - news 2 - news 3 *14.04.2004.* - news 4 *15.04.2004.* - news 5 .. I'm thinking of some while loop but I'm not sure that it will work nor I know how to create that query. TNX -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -------------------------------------------------------------------- Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911