search for multiple table

[kmyousafzai]

i have three table (user,movie,music) which all have an colum(country) and
i want to retreive country name as same time
my query is like this but it doesn't work any idea please..


$QuerySelect="SELECT * FROM movie,music,user WHERE `country` LIKE'%$name%'";

[phpsales]

Please place a white space after LIKE:

Before:
$QuerySelect="SELECT * FROM movie,music,user WHERE `country` LIKE'%$name%'";

After:
$QuerySelect="SELECT * FROM movie,music,user WHERE `country` LIKE '%$name%'";