5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

PHP not querying a specific table in mysql?!

by David Reed
4 replies
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
#mysql #php #querying #specific #table
  • Profile picture of the author David Reed
    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.....
    {{ DiscussionBoard.errors[3704262].message }}
  • Profile picture of the author xrvel
    "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
    {{ DiscussionBoard.errors[3704267].message }}
    • Profile picture of the author David Reed
      Originally Posted by xrvel View Post

      "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
      That's even better, now I don't have to change any of my data diagrams. Damned uni and their strict guidelines.

      Thanks
      {{ DiscussionBoard.errors[3704288].message }}
  • Profile picture of the author SteveJohnson
    here's one for your bookmark folder: MySQL :: MySQL 5.1 Reference Manual :: 8.3 Reserved Words
    Signature

    The 2nd Amendment, 1789 - The Original Homeland Security.

    Gun control means never having to say, "I missed you."

    {{ DiscussionBoard.errors[3704548].message }}

Trending Topics