Jump to content


Photo

PHP/MySQL - ORDER BY


  • Please log in to reply
2 replies to this topic

#1 DXPhoenix323

DXPhoenix323
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 09 June 2006 - 03:03 AM

So far, I can get this to work:

$query003 = "SELECT * from statement_details WHERE invoice_number = '$invoice_number'";

But when I add the ORDER BY like so:

$query003 = "SELECT * from statement_details WHERE invoice_number = '$invoice_number' ORDER BY order ASC";

I get errors... If I knew how to use those very interesting Mysql Error functions, I would... But, I don't... ,'|

Anyone know how to properly phrase this?

Thanks in advance,
-Ross :D

#2 poirot

poirot
  • Members
  • PipPipPip
  • Advanced Member
  • 646 posts
  • LocationAustin, TX

Posted 09 June 2006 - 03:33 AM

Use:
mysql_query($query003) or die(mysql_error());
This will return MySQL's error if any.

That should be OK; are you sure you are using a correct field name for ORDER BY?
~ D Kuang

#3 DXPhoenix323

DXPhoenix323
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 09 June 2006 - 03:45 AM

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]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 ASC' at line 1[/quote]

That's the error that comes up...

and yeah, it's a valid field... I'm sure... very sure... very... ,'|

could it be that the field name is order and it's causing the query to think I'm doubling the 'Order By' by following it with 'Order' ?

... I just answered my own question... I put the second order inside of these: ' ' making:

$query003 = "SELECT * from statement_details WHERE invoice_number = '$invoice_number' ORDER BY 'order' ASC";

and it now works...

I'm so impatient, especially when I'm loaded up with Pepsi...

-Ross :D




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users