[thelist] getting last entry from a table (mysql)

Alex Beston alex at deltatraffic.co.uk
Thu Oct 20 03:08:47 CDT 2005


hi evolt

im trying to access the most recent row of a table.

ive used   mysql_insert_id() to get the id of an insert just performed, 
but this one is to find the one with the largest id, which could have 
been added any time in the past.

currently using the first row returned from fetch_rows which is 
obviously very inefficient.

ok thanks
Alex

-- 
-------------------------------------------

Office: 01273 297927 / mobile: 07814 630621

-------------------------------------------




More information about the thelist mailing list