SA-MP Forums Archive
MySQL issues. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL issues. (/showthread.php?tid=453766)


MySQL issues. - Kebab- - 26.07.2013

Solved

Respuesta: MySQL issues. - Xabi - 26.07.2013

Check the WHERE clause, you have

pawn Код:
WHERE ID = 'd'
and should be

pawn Код:
WHERE ID = %d
Also, you have in most of them '%d', and only %s needs the '' in a query, as %d means an integer value.

Re: Respuesta: MySQL issues. - Kebab- - 26.07.2013

Quote:
Originally Posted by Xabi
Посмотреть сообщение
Check the WHERE clause, you have

pawn Код:
WHERE ID = 'd'
and should be

pawn Код:
WHERE ID = %d
Also, you have in most of them '%d', and only %s needs the '' in a query, as %d means an integer value.
I figured it out, it wasn't the clause infact. However, I also forgot the "%" beforehand. A stupid mistake to make, sorry for my stupidity. On the other hand, thanks.