kustomjs Posted October 5, 2007 Share Posted October 5, 2007 Hey Guys When I try to edit orders I get this error message: 1064 - 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 'where orders_id = '1'' at line 1 select customers_name, customers_email_address, orders_status, date_purchased ,ipaddy, ipisporders where orders_id = '1' I cant understand why its throwing this stupid error for? Link to comment Share on other sites More sharing options...
alexrebs Posted October 5, 2007 Share Posted October 5, 2007 select customers_name, customers_email_address, orders_status, date_purchased ,ipaddy, ipisporders where orders_id = '1'I cant understand why its throwing this stupid error for? From which table do you select??? Yes, thats the mistake;) select customers_name, customers_email_address, orders_status, date_purchased ,ipaddy, ipisporders [color="#ff0000"]from test_table[/color] where orders_id = '1' Link to comment Share on other sites More sharing options...
kustomjs Posted October 5, 2007 Author Share Posted October 5, 2007 what do you mean what table? Link to comment Share on other sites More sharing options...
kustomjs Posted October 5, 2007 Author Share Posted October 5, 2007 Now I get this error: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. but when I hit the back button it shows its been updated? Link to comment Share on other sites More sharing options...
kustomjs Posted October 6, 2007 Author Share Posted October 6, 2007 can anybody help me here? Link to comment Share on other sites More sharing options...
kustomjs Posted October 7, 2007 Author Share Posted October 7, 2007 anybody? Link to comment Share on other sites More sharing options...
alexrebs Posted October 10, 2007 Share Posted October 10, 2007 anybody? look: that's your query select customers_name, customers_email_address, orders_status, date_purchased ,ipaddy, ipisporders where orders_id = '1' but there isn't specified the table you want to select the data from. read your query, there's "from" missing Look here Link to comment Share on other sites More sharing options...
kustomjs Posted October 12, 2007 Author Share Posted October 12, 2007 Now I get this error: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. but when I hit the back button it shows its been updated? anybody know why i am getting this error? Link to comment Share on other sites More sharing options...
Guest Posted October 13, 2007 Share Posted October 13, 2007 Go to control panel at your host and run chck on dbase.If error come out tell it to fix.That my help. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.