mysql problem - 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 problem (/showthread.php?tid=549548)
+- 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 problem (/showthread.php?tid=549548)
mysql problem - BoU3A - 07.12.2014
PHP код:
mysql_format(Mysql,q,sizeof(q),"SELECT * FROM `players` WHERE `Username` = `%e` LIMIT 1",name);
PHP код:
(error #1054) Unknown column 'LOOOL' in 'where clause'
Re: mysql problem - Vince - 07.12.2014
Get rid of the backticks around the column names. They're completely unnecessary. String are wrapped in single quotes ('), not backticks (`).
Re: mysql problem - BoU3A - 07.12.2014
exmple please