Lotto mysql "NULL" string ?!
#2

Quote:

[20:27:43] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`Bilet = 262' at line 1

Pretty much all you need for debug, just search for
[quote]`Bilet = 262[quote]
You are missing enclosing backtick. So, search for
pawn Код:
format( gsString, 256, "SELECT * FROM `loterie` WHERE `Bilet = %d", randlotto);
//and replace it with
format( gsString, 256, "SELECT * FROM `loterie` WHERE `Bilet` = %d", randlotto);
Reply


Messages In This Thread
Lotto mysql "NULL" string ?! - by Metharon - 03.12.2014, 17:47
Re: Lotto mysql "NULL" string ?! - by Misiur - 03.12.2014, 18:28

Forum Jump:


Users browsing this thread: 1 Guest(s)