One field only

[[deleted]]

Hi there,

Can anyone tell me how to get the latest field or row (and then field) in my MySQL database?

many thanks!

[bretticus]

By latest you can use a query with ORDER BY, DESC and LIMIT

SELECT field FROM table ORDER BY submitdate DESC LIMIT 1

...or if your script has just inserted the record, you can use LAST_INSERT_ID() where your table has an auto-incremented id field.

SELECT field FROM table WHERE table_id = LAST_INSERT_ID()