Hello, I contacted X-Cart and they said this was not possible, but I can't accept that! Well they actually said that I would have to purchase some additional thing from them. I THINK NOT!!! Anyway, I building a shoe store and I want customers to be able to search by size. All sizes are entered in the "product_options tabe. I look at the table and I saw the following:
xcart_product_options
productid
----------
16136
optclass
---------
Size
opttext
--------
Size
options
--------
6
7
7.5
8
8.5
9
So that gave me an idea so I tried the following query, but no results are returned:
Code:
$match ="7";
// the database query
$query = "SELECT * FROM $sql_tbl[products],$sql_tbl[product_options] WHERE forsale='Y' AND avail>0 AND $sql_tbl[products].productid LIKE $sql_tbl[product_options].productid AND $sql_tbl[product_options].options LIKE $match ORDER by xcart_products.product ASC LIMIT 0,20 ";
ANY SUGGESTIONS?????