Fetching (and displaying) the 3 newest items from MySQL

From: 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

« previous php.db (#5276) next »