R: [PHP-GENERAL] mysq: get the latest row of a table

Hi Peter, > I've been thinking about this on and off now for a while, is there a fast > way to just get the latest row of a table? Looping through all just seems > like such a waste of time, I'm sure there must be a better way! > Thanks for any hints you can give, > Peter Just order the table descending, and limit your query to 1 row. Example: SELECT name,address FROM addressbook ORDER BY name DESC LIMIT 1; It will return a table of one row. That row will have the last item (ordered by name) of your table. Best Regards, -- Federico Pomi http://www.Pomi.net