Guest Posted January 7, 2009 Share Posted January 7, 2009 All our Products A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z All Products 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 p.products_id, products_weight, p.products_quantity, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from(( products p )left join manufacturers m on p.manufacturers_id = m.manufacturers_id )left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where pd.products_name like 'K%' AND p.products_status='1' order by pd.products_name limit -20, 20 [TEP STOP] http://comtekcomputers.com/allprods.php Link to comment Share on other sites More sharing options...
Guest Posted January 7, 2009 Share Posted January 7, 2009 All our Products A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z All Products 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 p.products_id, products_weight, p.products_quantity, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from(( products p )left join manufacturers m on p.manufacturers_id = m.manufacturers_id )left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where pd.products_name like 'K%' AND p.products_status='1' order by pd.products_name limit -20, 20 [TEP STOP] http://comtekcomputers.com/allprods.php It Looks Like its only Catagorys with no Products in looks llike it is erroring on the fact that thier is no data UGG Link to comment Share on other sites More sharing options...
sLaV- Posted January 7, 2009 Share Posted January 7, 2009 Your server has upgraded their MYSQL version 1064 - You have an error in your SQL syntax, A Fix for this MySQL v 4.1.xx problem Link to comment Share on other sites More sharing options...
Guest Posted January 7, 2009 Share Posted January 7, 2009 Your server has upgraded their MYSQL version 1064 - You have an error in your SQL syntax, A Fix for this MySQL v 4.1.xx problem THANKS THAT DID IT !!!!! :rolleyes: 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.