SQL syntax error in query

Question

What is wrong with my MySQL Query that is displaying the 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 'index WHERE id=1' at line 1

Relevant code:

$qu = mysql_query("SELECT * FROM index WHERE id= 1") or die("MySQL ERROR: ".mysql_error());

    WHILE($d = mysql_fetch_array($qu)):

    $con = $d['content'];

endwhile;

Michael Berkowski · Accepted Answer · 2012-07-25 16:04:34Z

7

index is a MySQL reserved keyword, so you must quote it with backticks like this:

SELECT * 
FROM `index` 
WHERE id = 1

edited Jul 25, 2012 at 16:04

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

answered Jul 25, 2012 at 16:02

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

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

1 Comment

tadman Over a year ago

In other words, if you can come up with a better name for that table, you might want to rename it.

Collectives™ on Stack Overflow

SQL syntax error in query

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