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); Thanks