PHP/MySQL - ORDER BY
Posted 09 June 2006 - 03:03 AM
$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,
Posted 09 June 2006 - 03:33 AM
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?
Posted 09 June 2006 - 03:45 AM
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...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users