[Gammix]

Quote:

Originally Posted by LoLeRo Now working, thanks you a lot!! But one question, if im expecting only one field, then why i have to put "LIMIT 1"?

The LIMIT is for rows not fields, and you are not expecting one field, you are extracting data from more than 10 fields ("userid", "admin", "vip" etc.).

LIMIT 1 means only one row will be loaded in cache/result.