SELECT last entry?

[mikeymizrahi]

I am trying to set up a very very simple CMS for a website- a status update.

 

I am using an html form to post to a database and am then displaying the "status."

When I display the status, it shows all the previous entries- Is there a function to display the last or most recent entry?

 

I have tried numerous different ways- even using UPDATE instead of INSERT but had no luck.

Help?

 

[AndyB]

Typically for your query to select the most recent the SQL syntax is along the lines

 

SELECT * from database_tablename ORDER by id DESC LIMIT 1

[fenway]

Or last_insert_id if it really is an insert.