show last record entered as default

[webguync]

I have mastered the art of displaying results from MySQL into a web page via SQL Queries and

while ($row = mysql_fetch_array($result)) {

 

what I need to do though and am not sure how to go about it is to display only the last record entered into MySQL into my html table, so that each and every time a new record is entered that (1) and only one is displayed.

 

thanks in advance for any assistance.

[alecks]

If you have a 'time' column filled with timestamps of when the row is added, you can make a query like SELECT * FROM table ORDER BY time DESC LIMIT 1

[JSHINER]

Assign an ID to each then

"SELECT * FROM table ORDER BY id DESC LIMIT 1"

 

 

[teng84]

you may use <a href="http://www.php.net/manual/en/function.mysql-insert-id.php">mysql_insert_id</a> if you're using the current connection..

 

[webguync]

thanks for the ideas. I got a working script using a timestamp and sorting desc limit 1