How to get the last field in a Mysql database with PHP?

Question

I have mysql database and I want to get the last ID from field in a table .

example : -

id   Value
1    david
2    jone
3    chris

I want a function return 3 if this table exist .

Answer 1

You can use:

SELECT MAX(id) FROM table

Answer 2

If you want to select the ID of the most recently inserted row in a table with an AUTO_INCREMENT column, you will likey be interested in MySQL's LAST_INSERT_ID function.

Answer 3

SELECT id
FROM table
ORDER BY id DESC
LIMIT 1