MySQL Query Help
- by Andy
I need to find the category id in the products table below. However the cms_ecom_categories.id is wrapped with the & character like &12&. Is there some kind of wild card i could use to wrap around? like %cms_ecom_categories.id% ?
$sql = "SELECT * FROM cms_ecom_products, cms_ecom_categories
WHERE cms_ecom_products.pCategories = cms_ecom_categories.id
AND cms_ecom_categories.slug = ".$page."";
Thanks to all in advance who can help.