Search a word in multiple tables
| From: | Phpu | Date: | Fri, 05 Nov 2004 12:27:36 +0000 |
| Subject: | Search a word in multiple tables | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-201279@lists.php.net to get a copy of this message | ||
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