Mysql/PHP issues using WHERE

Camron · 08-13-2007, 02: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.

Any help is much appreciated

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

Replace

PHP Code:

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

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, 02:11 PM

Thanks a bunch, rep added!

-PS- · 08-13-2007, 03: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, 02:04 PM	#1 (permalink)
Camron Senior Member Join Date: Jan 2006 Location: Portland, Oregon Posts: 2,059 24.85 NP$ (Donate)	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. Any help is much appreciated

08-13-2007, 02:07 PM	#2 (permalink)
cheerio NamePros Member Join Date: Jun 2007 Posts: 52 90.00 NP$ (Donate)	Replace PHP Code: `$result = mysql_query("SELECT * FROM order WHERE status='pending'") or die(mysql_error());` 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, 02:11 PM	#3 (permalink)
Camron Senior Member Join Date: Jan 2006 Location: Portland, Oregon Posts: 2,059 24.85 NP$ (Donate)	Thanks a bunch, rep added! __________________ \|\| VPSByte Virtual & Dedicated Solutions \|\| True 24/7/365 support with a 1 hour guaranteed response time! \|\| We offer budget, yet powerful dedicated servers and vps solutions. \|\| All servers come w/ 10Mbps unmetered bandwidth & lite management standard.

08-13-2007, 03:44 PM	#4 (permalink)
-PS- NamePros Regular Join Date: Jun 2006 Location: Sydney Posts: 251 5.95 NP$ (Donate)	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)