Getting the last line added from mysql

kumschick

Hi,

How can i get the last inserted row out from the mysql DB?

...
$sql_content=mysql_query("select * from $co",$connection);
while($row=mysql_fetch_array($sql_content))
  {
    echo "
      ...
      <p>Last Winner: $row[name]</p>
      ...
  ";
  }
...

Thx for any help

YappyDog

Don't have the exact syntax, but you should be able to do something using the limit option in your select statement. If you order by an id column in descending order, and then limit to 1, you should get your most recent insertion.

laserlight

One way would be to use [man]mysql_insert_id/man to get the index of that row, then use it to retrieve the whole row.

Another way would use what YappyDog suggested, say:
SELECT * FROM tablename ORDER BY table_id DESC LIMIT 1