Mysql/PHP issues using WHERE

[Camron]

I'm currently using the following code to select and get info from the database:

(I am using mysql 5 and php 5)

$result = mysql_query("SELECT * FROM order WHERE status='pending'") or die(mysql_error());  
while($row = mysql_fetch_array( $result )) {  

<outputs the data here>

}

Now on the page it displays:

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 WHERE status='pending'' at line 1

This is really weird because I have never had such issue before. I have another script using almost identical code and it's working fine.

Any help is much appreciated

 

[cheerio]

Replace

  $result = mysql_query("SELECT * FROM order WHERE status='pending'") or die(mysql_error());

with

  $result = mysql_query( "SELECT * FROM `order` WHERE `status`='pending'" ) or die(mysql_error());

"order" is an SQL Keyword - "ORDER BY fieldname DESC/ASC"

 

[Camron]

Thanks a bunch, rep added!

 

[-PS-]

Camron, it would be good pratice to put `` around your field names, the better you get at creating complex queries, the easier it be to make mistakes, or use "keywords" in your queries.

=)