Mysql/PHP issues using WHERE

Camron · 08-13-2007, 03:04 PM

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

(I am using mysql 5 and php 5)

PHP Code:

  $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:

Code:

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.
????: NamePros.com http://www.namepros.com/programming/361370-mysql-php-issues-using-where.html

Any help is much appreciated

cheerio · 08-13-2007, 03:07 PM

Replace

PHP Code:

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

????: NamePros.com http://www.namepros.com/showthread.php?t=361370

with

PHP Code:

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

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

Camron · 08-13-2007, 03:11 PM

Thanks a bunch, rep added!

-PS- · 08-13-2007, 04:44 PM

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.

=)

08-13-2007, 03:04 PM	THREAD STARTER #1 (permalink)
Camron Senior Member Join Date: Jan 2006 Location: Portland, Oregon Posts: 2,102 Follow @hostingfuze	Mysql/PHP issues using WHERE I'm currently using the following code to select and get info from the database: (I am using mysql 5 and php 5) PHP Code: `$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: Code: 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. ????: NamePros.com http://www.namepros.com/programming/361370-mysql-php-issues-using-where.html Any help is much appreciated

08-13-2007, 03:07 PM	#2 (permalink)
cheerio NamePros Member Join Date: Jun 2007 Posts: 52	Replace PHP Code: `$result = mysql_query("SELECT * FROM order WHERE status='pending'") or die(mysql_error()); ????: NamePros.com http://www.namepros.com/showthread.php?t=361370` with PHP Code: $result = mysql_query( "SELECT * FROM `order` WHERE `status`='pending'" ) or die(mysql_error()); "order" is an SQL Keyword - "ORDER BY fieldname DESC/ASC" __________________ ProxyPimps TreatmentofMesothelioma \| PinkSocks \| Cakebite \| Treeless

08-13-2007, 03:11 PM	THREAD STARTER #3 (permalink)
Camron Senior Member Join Date: Jan 2006 Location: Portland, Oregon Posts: 2,102 Follow @hostingfuze	Thanks a bunch, rep added! __________________ HostingFuze.com Premium Master Reseller Services \| 99.9% Uptime Guaranteed SLA \| Starting at $4.95/mo Basic Reseller Hosting @ HostFz.com - Services starting as low as $1.95/mo!

08-13-2007, 04:44 PM	#4 (permalink)
-PS- NamePros Regular Join Date: Jun 2006 Location: Sydney Posts: 251	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. =) __________________ Site Armory, tools for your website \| Webmaster SEO Forums \| PHP Tutorial and coding forums

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)