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

-----Original Message-----
From: T. H. Grejc [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 1:50 PM
Subject: [PHP-DB] Select news based on dates


I would like to display my news like this:

- news 1
- news 2
- news 3
- news 4
- 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.


PHP Database Mailing List (
To unsubscribe, visit:

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 or call +27 (0)21 460 3911

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to