Guest Posted January 8, 2009 Share Posted January 8, 2009 All Products 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 ')left join specials s on p.products_id = s.products_id where pd.products_name l' at line 1 select count(p.products_id) as total 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 '%' AND p.products_status='1' :blink: Quote Link to comment Share on other sites More sharing options...
Guest Posted January 8, 2009 Share Posted January 8, 2009 The page is allprods.php in your catalog directory Quote Link to comment Share on other sites More sharing options...
Guest Posted January 9, 2009 Share Posted January 9, 2009 The page is allprods.php in your catalog directory In that case Im going crazy I cannot find the error in this code So much for my Video Traing PHP Training Im paying for :P Quote Link to comment Share on other sites More sharing options...
Guest Posted January 9, 2009 Share Posted January 9, 2009 In that case Im going crazy I cannot find the error in this code So much for my Video Traing PHP Training Im paying for :P mines says (if that helps) $listing_sql = "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 " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where"; Quote Link to comment Share on other sites More sharing options...
Guest Posted January 12, 2009 Share Posted January 12, 2009 mines says (if that helps) $listing_sql = "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 " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where"; YOU ARE AWSOME THANKS !!!!!!! :rolleyes: Quote Link to comment Share on other sites More sharing options...
Guest Posted January 12, 2009 Share Posted January 12, 2009 (edited) WOW Nice Store is that a Addon that makes the page changes fade in and out ? " I googled the name HEHEHE " Edited January 12, 2009 by marvinlange Quote Link to comment Share on other sites More sharing options...
Guest Posted January 12, 2009 Share Posted January 12, 2009 YOU ARE AWSOME THANKS !!!!!!! :rolleyes: Glad it helped. Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.