Help mysql error
#2

Exists is mysql reserved keyword, you need to escape them with backtick `
https://dev.mysql.com/doc/refman/5.0/en/keywords.html
Here's the right syntax.
Код:
format(query,sizeof query,"SELECT COUNT(*) AS `exists` FROM factions WHERE facname='%s'",localfname);
Reply


Messages In This Thread
Help mysql error - by maikons - 22.09.2015, 01:25
Re: Help mysql error - by X337 - 22.09.2015, 03:21
Re: Help mysql error - by maikons - 22.09.2015, 06:04

Forum Jump:


Users browsing this thread: 2 Guest(s)