Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
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
UserValidation
Something like this will work:
select UserID,UserName from `UserValidation` order by UserID descLIMIT 0,1