|
|
Posted by JDS on 10/31/05 17:36
On Sun, 30 Oct 2005 18:49:28 +0100, Colin Roosendaal wrote:
> I'm looking for the PHP/MySQL query to get the last 5 added records from
> my database/table.
It depends on how "last five records" is defined.
Is there a date field in the database?
Is there a numeric, auto-incremented ID field?
In other words, is there any field which can be used to track what field
was most recently added?
Is "most recently added" the ones you want? Or do you just want the bottom
five rows after a particular ORDER BY clause has been applied?
Also, this is *really* not an HTML question. Try alt.php or alt.php.sql
or comp.lang.php or other closer-to-on-topic group for more help.
--
JDS | jeffrey@example.invalid
| http://www.newtnotes.com
DJMBS | http://newtnotes.com/doctor-jeff-master-brainsurgeon/
Navigation:
[Reply to this message]
|