Select From Database

[kees mekhalel]

I want and SQL Select Command That

select row where it have the maximam ID

like

select Max(ID) From Table

It will retrieve the maximum ID

but i want to retrieve the whole row

[omoutop]

hi!
if u need the whole row then u need another query below to select * from Table where ID = '$ID' (which is the one u have just retrieved in the previous query)....u run the query and fetch all remaining data....hope the best..!

[kees mekhalel]

Thank You for your replay but there is now a one sql statement

[jpjones]

Try

SELECT * FROM Table ORDER BY ID DESC LIMIT 1

This has the effect of returning the full contents of 1 row, with the highest (Max) ID.

[kees mekhalel]

Thank You

It works correctly

I hope i will help you