RE: [PHP] Search a word in multiple tables

2004-11-05 Thread Murray @ PlanetThoughtful
Hi, How can i search a specific word in 2 tables I use this but it is not working sql = SELECT a.product_id, a..select_language('product_name_en', 'product_name_fr')., b.brand_name FROM products_accessories as a, brands as b WHERE (a..select_language('product_name_en',

Re: [PHP] Search a word in multiple tables

2004-11-05 Thread raditha dissanayake
Phpu wrote: Hi, How can i search a specific word in 2 tables I use this but it is not working sql = SELECT a.product_id, a..select_language('product_name_en', 'product_name_fr')., b.brand_name FROM products_accessories as a, brands as b WHERE (a..select_language('product_name_en',