SQLite help.
#3

Quote:
Originally Posted by Gammix
Посмотреть сообщение
You are only selecting one field i.e. "username" in the query. So expect only one field's result.

And your query is pretty much all messed up.
- No use of "`" for table and column names
- LIMIT having multiple values

Corrected query:
pawn Код:
SELECT * FROM `users` WHERE `username` = '%s' LIMIT 1
Now working, thanks you a lot!! But one question, if im expecting only one field, then why i have to put "LIMIT 1"?
Reply


Messages In This Thread
SQLite help. - by LoLeRo - 26.07.2016, 02:58
Re: SQLite help. - by Gammix - 26.07.2016, 03:07
Respuesta: Re: SQLite help. - by LoLeRo - 26.07.2016, 03:22
Re: Respuesta: Re: SQLite help. - by Gammix - 26.07.2016, 03:26
Respuesta: SQLite help. - by LoLeRo - 26.07.2016, 03:43
Re: Respuesta: SQLite help. - by Gammix - 26.07.2016, 03:46
Respuesta: SQLite help. - by LoLeRo - 26.07.2016, 03:48

Forum Jump:


Users browsing this thread: 1 Guest(s)