> 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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
