Get last ID and display it

php mysql mysql-insert-id
Onz picture Onz · Feb 14, 2012 · Viewed 7.3k times · Source

I've been looking around but most of the tutorials are showing the mysql_insert_id() but it's on the same document. I'm wondering if there is a way where you can get the last id of a column and echo it out.

$image = mysql_query("SELECT * FROM images WHERE id=$id");
$image = mysql_fetch_assoc($image) or die(mysql_error());

$image = $image['image'];

header("Content-type: image/jpeg");

echo $image;

This is my code that gets the image from the database and makes the blob into a id?=1 which is the picture but as php. That is a uploader from another php document but I'm typing to output the last id from that column on another page (Not the picture but the number for statistics)

A bit of code that could do that would be very helpful.

Answer

Cyclonecode picture Cyclonecode · Feb 14, 2012

This would grab the row with the highest ID:

$result = mysql_query("SELECT MAX(id) FROM images");
$row = mysql_fetch_row($result);
// $row[0] contains the value of the highest id

Related questions

mysql_insert_id() returns 0

I know there are a lot of topics with the same title. But mostly it's the query that's been inserted in the wrong place. But I think I placed it right. So the problem is, that I still get 0 even …

Read More
Fatal error: Uncaught exception 'mysqli_sql_exception' with message 'No index used in query/prepared statement'

When I run the following code, I get the error saying Fatal error: Uncaught exception 'mysqli_sql_exception' with message 'No index used in query/prepared statement' $mysql = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die(…

Read More
getting mysql_insert_id() while using ON DUPLICATE KEY UPDATE with PHP

I've found a few answers for this using mySQL alone, but I was hoping someone could show me a way to get the ID of the last inserted or updated row of a mysql DB when using PHP to handle …

Read More