php-db | 2000121

[PHP-DB] Fetching (and displaying) the 3 newest items from MySQL From: Mattias Johansson (smart <email protected>)
Date: 12/15/00

Hi, I'm a newbie in need of your great wisdom.

I need help on how to fetch the three most newly added items from a specific
table in a MySQL database. The records in the table are NOT dated, but they
do contain have an ID, that is highest for the most newly added item. So,
what I want to do is:

1. Take the table and order it with the highest ID first
2. And then take the first 3 items.
3. After that, I also need to display the 3 items, of course!

Can you please help me? I'm very new to PHP, but so far I'm very impressed
by it!

/Mattias 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>