DXPhoenix323

[!--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

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

[!--quoteo(post=381707:date=Jun 8 2006, 10:45 PM:name=jacobjmorris)--][div class=\'quotetop\']QUOTE(jacobjmorris @ Jun 8 2006, 10:45 PM) [snapback]381707[/snapback][/div][div class=\'quotemain\'][!--quotec--] My php include is not working: <?php include('/components/include/banner.php'); ?> This is the error message I get: Warning: main(): open_basedir restriction in effect. File(/components/includes/banner.php) is not within the allowed path(s): (/home/gayeecom/:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/gayeecom/public_html/about/index.php on line 26 However, if I were to move banner.php within the same folder as the file I'm trying to include it, then it works fine. So, I'm guessing this has something to do with how I'm constructing the file path? Jacob [/quote] I used to get something similar to this back when PHP upgraded to PHP4... Try adding the at sign @ between <?php and include to create: <?php @ include('/components/include/banner.php'); ?> That should do it... PHP can be analretentive with technicalities... Let me know if that works... -Ross :D