RE: [PHP] Search a word in multiple tables

> 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_fr')." LIKE '%".$word."%' OR b.brand_name > LIKE > '%".$word."%')"; > $result= mysql_query($sql); Are you using MySQL? If so, depending on which version you have, it might be worth checking out UNION queries. http://dev.mysql.com/doc/mysql/en/UNION.html Much warmth, Murray http://www.planetthoughtful.org Building a thoughtful planet, One quirky comment at a time.