WTF IS THIS MYSQL INI
#2

pawn Код:
format(Query,sizeof(Query),"SELECT * `users` WHERE username = %s LIMIT 1",pName);
//to
format(Query,sizeof(Query),"SELECT * FROM `users` WHERE username = '%s' LIMIT 1", pName);
Try to not use the * wildcard, just specify the field names.

2. https://sampwiki.blast.hk/wiki/MySQL#mysql_fetch_field_row
Reply


Messages In This Thread
WTF IS THIS MYSQL INI - by TheDeath - 27.07.2012, 10:20
Re: WTF IS THIS MYSQL INI - by Misiur - 27.07.2012, 10:24
Re: WTF IS THIS MYSQL INI - by TheDeath - 27.07.2012, 10:26
Re: WTF IS THIS MYSQL INI - by Misiur - 27.07.2012, 10:33
Re: WTF IS THIS MYSQL INI - by TheDeath - 27.07.2012, 10:37
Re: WTF IS THIS MYSQL INI - by Misiur - 27.07.2012, 10:39
Re: WTF IS THIS MYSQL INI - by Vince - 27.07.2012, 10:46
Re: WTF IS THIS MYSQL INI - by TheDeath - 27.07.2012, 11:30
Re: WTF IS THIS MYSQL INI - by FireCat - 27.07.2012, 11:41
Re: WTF IS THIS MYSQL INI - by Calgon - 27.07.2012, 11:47

Forum Jump:


Users browsing this thread: 1 Guest(s)