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

Question

Hi 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

SELECT id
FROM table
ORDER BY id DESC
LIMIT 1

Answer 2

SELECT MAX(id) FROM table

Answer 3

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.