Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

error in your SQL syntax


Guest

Recommended Posts

Posted

Hi I have n error at line 1 in my msql i give ya the message just told me what i need to do n were i have to go in my os c thx for a response Mike

 

 

 

1064 at line 1

Status: Open

Assigned To: unassigned

Created: 30th November 2005 23:26:45

Reporter: ltswat (AT) comcast (DOT) net

Version: 2.2-MS2

Type: Database (General)

PHP Version: 5

 

Customers Order Total Date Purchased Status Action

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

'-20, 20' at line 1

 

select o.orders_id, o.customers_name, o.customers_id, o.payment_method,

o.date_purchased, o.last_modified, o.currency, o.currency_value,

s.orders_status_name, ot.text as order_total from orders o left join

orders_total ot on (o.orders_id = ot.orders_id), orders_status s where

o.customers_id = '2' and o.orders_status = s.orders_status_id and

s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC

limit -20, 20

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...