Fetching (and displaying) the 3 newest items from MySQL
| From: | Mattias Johansson | Date: | Fri, 15 Dec 2000 20:34:53 +0000 |
| Subject: | Fetching (and displaying) the 3 newest items from MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5276@lists.php.net to get a copy of this message | ||
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