query for this?

[starfish]

what would be the query for getting the last record from a given table?

[richei]

mysql_query("SELECT * FROM table ORDER BY id DESC");

that's assuming you have an id field, just use whatever your auto incrementing field is.