RE: [PHP] Search a word in multiple tables

[Murray @ PlanetThoughtful]

 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

Re: [PHP] Search a word in multiple tables

[raditha dissanayake]

Phpu wrote:
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
 

does this become a PHP question just because of
$result= mysql_query($sql); ??

--
Raditha Dissanayake.

http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload
Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader
Graphical User Inteface. Just 128 KB | with progress bar.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php