Pag wrote:
One of the fields in my tables is "type" (values 0, 1, 2 etc), which divides the news into categories, how can i display like the 10 most recent entries of type = 2, for example?If your table is called mynews and it has a field called timestamp which contains the date/time the entry was made and you wanted the 10 most recent items of type 2, most recent first:
select * from mynews where type = 2 limit 10 order by timestamp desc;
Untested, but I think the syntax for MySQL is correct. Check in the MySQL manual if its not. Really a mysql list question.
HTH
Chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
