This topic is locked
[SOLVED]

 Pick Last Row in a Query

10/28/2010 4:35:04 PM
PHPRunner General questions
K
karmacomposer author

This query works in PHPMyAdmin:
select UserID,UserName from UserValidation
Now, it selects all records and shows the UserID and UserName
How do I have it only select the LAST RECORD?
Mike

Sergey Kornilov admin 10/28/2010

Something like this will work:

select UserID,UserName from `UserValidation`

order by UserID desc

LIMIT 0,1