PHP not querying a specific table in mysql?!

by 4 replies
5
Hi everyone

I'm getting an error when I try to query a specific table:

"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 'order' at line 1"

My code has and does work perfectly on all of my other tables in the same database, which is why I'm so confused about it :confused:

This is the code that's throwing an error:

$dispatch = mysql_query("SELECT * FROM order")or die(mysql_error());

but it is worded exactly the same as my other tables.

I checked the storage engines of each of the tables in PHPmyadmin,
all are innoDB...

Just completely stuck here.. any help would be appreciated
#programming #mysql #php #querying #specific #table
  • Nevermind, I fixed the problem now.

    Just to let everyone know, the problem was the table name. I just changed it from 'order' to 'orderstatus' and now it's working.

    I should have thought that using the word order as a table name would cause mySQL some headaches.....
  • "order" is a reserved keyword.

    Use this instead (notice the backtick)
    PHP Code:
     = mysql_query("SELECT * FROM `order`")or die(mysql_error()); 
    Update : oh okay you can just rename the table instead
    • [ 1 ] Thanks
    • [1] reply
    • That's even better, now I don't have to change any of my data diagrams. Damned uni and their strict guidelines.

      Thanks
  • here's one for your bookmark folder: MySQL :: MySQL 5.1 Reference Manual :: 8.3 Reserved Words
Join the discussion

Next Topics on Trending Feed