1064 - You have an error in your SQL syntax;

[renrom]

Dear All,

 

I am having big problems to eliminate the follwoing Mysql error when the wishlist is empty:

 

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 '-10, 10' at line 1

 

select * from customers_wishlist where customers_id = '10' order by products_name limit -10, 10

 

[TEP STOP]

 

Could anyone please help?

[♥geoffreywalton]

Believe if you follow first link in my sig block below there is a fix for a similar problem in a different contribution.

 

Worth a try?

[renrom]

Dear All,

 

I am having big problems to eliminate the follwoing Mysql error when the wishlist is empty:

 

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 '-10, 10' at line 1

 

select * from customers_wishlist where customers_id = '10' order by products_name limit -10, 10

 

[TEP STOP]

 

Could anyone please help?

 

You're the best Geoffrey... It worked perfectly fine. Thank you so much! Take Care

[♥geoffreywalton]

Try googling

 

site:www.oscommerce.com/forums select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date,

[♥geoffreywalton]

Don't you just love google!!