[SOLVED] searching for multiple keywords

[anthony-needs-you]

Hi i have two bits of code. On their own they work fine.

 

How would i put them together?

 

$result = mysql_query("SELECT departureDate, expireDate, airport, destination, resort, hotel, duration, board, price, description, customerRef, mystiqueRef, stars FROM holiday WHERE destination LIKE '%$where%'");[code]

$result = mysql_query("SELECT departureDate, expireDate, airport, destination, resort, hotel, duration, board, price, description, customerRef, mystiqueRef, stars FROM holiday WHERE duration LIKE '%$stay%'");[/code]

[premiso]

WHERE destination LIKE '%$where%'  OR duration LIKE '%$stay%'

 

Or keyword in the WHERE clause if you want either or AND if you want both to be true....

 

WHERE destination LIKE '%$where%'  AND duration LIKE '%$stay%'

 

[Maq]

Have you tried appending another conditional?  I think that should work.

 

$result = mysql_query("SELECT departureDate, expireDate, airport, destination, resort, hotel, duration, board, price, description, customerRef, mystiqueRef, stars FROM holiday WHERE destination LIKE '%$where%' AND duration LIKE '%$stay%'");

[Maq]

'OR' & 'AND' should both work depending on what restrictions you want.  But looks like premiso is right with the 'OR' 

[anthony-needs-you]

Thanks works perfectly