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', 'pro

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',

[PHP] Search a word in multiple tables

2004-11-05 Thread Phpu
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', 'product_name