mysql r7 register/login problem
#6

Strings _have to_ be surrounded by quotes. That's why you should use mysql_format / mysql_real_escape_string.

pawn Код:
//Not like this
format(query,sizeof(query),"SELECT * FROM `players` WHERE `Name`=%s",name(playerid));
//More like this
mysql_format(connection, query, "SELECT * FROM `players` WHERE Name = '%e'", name(playerid));
Reply


Messages In This Thread
mysql r7 register/login problem - by newbienoob - 18.03.2013, 14:44
Re: mysql r7 register/login problem - by Scenario - 18.03.2013, 14:53
Re: mysql r7 register/login problem - by newbienoob - 18.03.2013, 15:00
Re: mysql r7 register/login problem - by Scenario - 18.03.2013, 15:02
Re: mysql r7 register/login problem - by newbienoob - 18.03.2013, 15:08
Re: mysql r7 register/login problem - by Misiur - 18.03.2013, 15:15
Re: mysql r7 register/login problem - by Scenario - 18.03.2013, 15:18
Re: mysql r7 register/login problem - by Misiur - 18.03.2013, 15:22
Re: mysql r7 register/login problem - by Scenario - 18.03.2013, 15:23
Re: mysql r7 register/login problem - by newbienoob - 18.03.2013, 15:27
Re: mysql r7 register/login problem - by Misiur - 18.03.2013, 15:33
Re: mysql r7 register/login problem - by newbienoob - 19.03.2013, 07:26
Re: mysql r7 register/login problem - by Vince - 19.03.2013, 07:55
Re: mysql r7 register/login problem - by newbienoob - 19.03.2013, 11:36
Re: mysql r7 register/login problem - by newbienoob - 22.03.2013, 06:24
Re: mysql r7 register/login problem - by ReneG - 22.03.2013, 06:53
Re: mysql r7 register/login problem - by newbienoob - 23.03.2013, 05:41
Re: mysql r7 register/login problem - by ReneG - 23.03.2013, 06:11
Re: mysql r7 register/login problem - by newbienoob - 23.03.2013, 06:28

Forum Jump:


Users browsing this thread: 6 Guest(s)