prod_id
name
sku
description
image
disp_order
active
and then there are two tables for "custom fields" which look like:
s01_CFM_ProdFields - this table stores custom fields that are available
id
code
name
s01_CFM_ProdValues - this table relates custom fields to products...
field_id
prod_id
value
So I need to be able to search the product table as well as certain CFM_ProdFields within the CFM_ProdValues table. I am thinking something like:
Code: Select all
SELECT *
FROM products, s01_CFM_ProdFields, s01_ProdValues
WHERE products.prod_id = s01_CFM_ProdValues.prod_id
AND MATCH(fields, to, search) AGAINST ('search terms')Thanks.