MYSQL where clause causes syntax error

Question

I just cannot find what is wrong with this simple statement:

$stat_qry = mysql_query("SELECT * FROM stats WHERE group=$galgroup") or die("STATS ERROR: ".mysql_error()); $stat = mysql_fetch_array($stat_qry);

i just get: "STATS ERROR: 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 'group=1' at line 1"

i cannot get it to work with the 'where' clause, if i remove 'where' it works but just lists everything in the database

Better idea: Don't use reserved words as column/table identifiers. And see about sql-injection, PHP's deprecated mysql API and prepared statements — Strawberry
– Strawberry, Commented Feb 27, 2015 at 19:25

Fabien TheSolution · Accepted Answer · 2015-02-27 19:24:44Z

2

GROUP is a reserved word so it needs to be between back tick `` Also, if $galgroup can be a string and not only a number, you need to add quotes arround it :

$stat_qry = mysql_query("SELECT * FROM stats WHERE `group`='$galgroup'") or 
die("STATS ERROR: ".mysql_error()); $stat = mysql_fetch_array($stat_qry);

answered Feb 27, 2015 at 19:24

Fabien TheSolution

5,0501 gold badge20 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mystic Over a year ago

i cant believe thats all it took, i spent all day trying to figure this out, recreated my tables, rewrote my code... argh. Thank you very much

Collectives™ on Stack Overflow

MYSQL where clause causes syntax error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related