Nonsensical mySQL error...

[morocco-iceberg]

I can't figure out what is going on here.

When I use this in my code:

 

$result = mysql_query("SELECT * FROM read")or die(mysql_error());
$number = mysql_numrows($result);

 

I get this 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 'read' at line 1

 

Because I couldn't find anything wrong I thought I'd check if there is actually a problem, so I changed the name of the table to 'list', like this:

 

$result = mysql_query("SELECT * FROM list")or die(mysql_error());
$number = mysql_numrows($result);

 

And it worked fine, I recieved no error message and the rest of the code output what I expected it to.

 

Any ideas what could be going wrong? I've checked the tables and they're fine (the list table is just a copy of the read table, so I don't see why it would be affecting the code.)

[Adam]

It's a reserved word in MySQL:

 

http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

[morocco-iceberg]

Aha, thanks.