[Joe Schwartz]

I've tried to adapt this code for my 4.0.12 x-cart store, but keep getting this error:

SELECT * from WHERE productid='13' Error code : 1064 Description : You have an error in your SQL syntax near 'WHERE productid='13'' at line 1

The error occurs with any product (any productid) regardless of whether or not it has product options. I'm pretty sure the error is in the products.php file in this section:

  // first we build a query to get all the product options with a single query
   $query="SELECT * from $sql_tbl[product_options] WHERE ";
   foreach($products as $key=>$value){
         $query.="productid='$value[productid]' ";
         if($i < $productcount-1){
            $query.="OR ";
         }
         $i++;
   } 

I know this is an old thread, but if anyone has adapted this code for 4.x.x of x-cart, I'd be grateful for any insight.

Many thanks,

Joe