How to get the latest record id

[manoq76]

hi..

i have a problem regarding how to get the latest record no for increament value.

Is there a way to get this record no without query the record??

regards
farizan

 

[KarveR]

select max(id) from table;
This will work if your id column is auto-increment as it wont re-use id's from deleted records. ***************************************
Party on, dudes!