help with error

[tnier]

Can anyone fully explain how to fix this error..

not just pont out the error..i need to know how and were to fix it

how to fix the duplicate "from"

 

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 ' backorders from orders where orders_id = '746'' at line 1

 

select customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from, backorders from orders where orders_id = '746'

 

[TEP STOP]

 

Thanks

[Velveeta]

Can anyone fully explain how to fix this error..

not just pont out the error..i need to know how and were to fix it

how to fix the duplicate "from"

 

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 ' backorders from orders where orders_id = '746'' at line 1

 

select customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from, backorders from orders where orders_id = '746'

 

[TEP STOP]

 

Thanks

Well, this is either gonna be in your includes/classes/orders.php file, or your admin/includes/classes/orders.php file, we can't tell for sure without some more info from you about where you're seeing this error... In addition, we can't tell you how to fix it without seeing the code that's constructing this query... So check those locations, and when you find the code that makes this query, post it here and we'll see what we can do...

 

Richard.