how to get the value of "id" of the last record in a mysql data base through php

Question

let's say there is a database called "db" and a table called "tb" and with some records in it. first column is "ID" which is "auto increment". i want to get the last record's ID to a php page.(i have already created the connection to the db)

$conn = new mysqli($servername, $username, $password, $dbname);

`SELECT MAX(ID) FROM tb` or `SELECT ID FROM tb ORDER BY ID DESC LIMIT 1` or ... — Sean, Apr 07 '15 at 17:19
possible duplicate of [SQL Select only rows with Max Value on a Column](http://stackoverflow.com/questions/7745609/sql-select-only-rows-with-max-value-on-a-column) — psadac, Apr 07 '15 at 17:48

Ghostman · Answer 1 · 2015-04-07T17:22:48.153

1

Select id from tb ORDER BY id desc limit 1

edited Apr 07 '15 at 17:22

answered Apr 07 '15 at 17:21

Ghostman

6,042
9
34
53

`DESC` not `ASC` as OP stated `i want to get the last record's ID` – Sean Apr 07 '15 at 17:22
Updated check the answer – Ghostman Apr 07 '15 at 17:23

score 0 · Answer 2 · answered Apr 07 '15 at 17:20

0

Are you looking for something like this:

mysqli_query("SELECT `ID` FROM `table` ORDER BY ID DESC limit 1");

answered Apr 07 '15 at 17:20

Keep Coding

636
9
26

score 0 · Answer 3 · answered Apr 07 '15 at 17:33

0

Here's the complete solution:

<?php 
$conn = new mysqli($servername, $username, $password, $dbname);
$rs = mysqli_query("SELECT MAX(id) as max_id FROM tb");
$res = mysql_fetch_object($rs);
echo $id = $res->max_id;
?>

answered Apr 07 '15 at 17:33

Raj Ankur

114
6

how to get the value of "id" of the last record in a mysql data base through php

3 Answers3