Help needed about search

[asifnayem]

Hi,

I want to make a search option for my site. I know the basic search criteria. it search from 1 feild. but I need that it should search from 2-3 feild.

example:

My feild names are: moviename, artist, coartist, keyword.
here keywords saves like: avengers, scarlet, tonny, (with comma).

When i put a name on the search box, it should search from all these field and provide me the results. but all I came up with these

$result = mysql_query("SELECT * FROM `movie_info` WHERE `moviename` LIKE '%$q%' LIMIT 0 , 30");
while ($row = mysql_fetch_array($result)) {
---
} 

Can anyone help me out in this?

[pankajb]

If your given code is working for single field then try this

 $result = mysql_query
( "SELECT * FROM `movie_info` WHERE `FIELDNAME1` LIKE '%
$q %' LIMIT 0 , 30" );
 $result = mysql_query
( "SELECT * FROM `movie_info` WHERE `FIELDNAME2` LIKE '%
$q %' LIMIT 0 , 30" ); 
 $result = mysql_query
( "SELECT * FROM `movie_info` WHERE `FIELDNAME3` LIKE '%
$q %' LIMIT 0 , 30" ); 
.
.
 .
. $result = mysql_query
( "SELECT * FROM `movie_info` WHERE `FIELDNAMES` LIKE '%
$q %' LIMIT 0 , 30" ); 
WHILE **********YOUR CODE**** 

Hope it will work

[arnage]

Its needed to use JOIN so check this for example: SQL Tutorial - Join

[pankajb]

Its needed to use JOIN so check this for example: SQL Tutorial - Join

My code will work fine if all fields are in single table...

[GumSlone]

$result = mysql_query("SELECT * FROM `movie_info` WHERE `moviename` LIKE '%$q%' OR `artist` LIKE '%$q%' OR `coartist` LIKE '%$q%' OR `keyword` LIKE '%$q%' LIMIT 0 , 30"); 

[asifnayem]

Thanks gummy it works. Thanks all.