Search a word in multiple tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux