MySql Query help needed

[jimjiminyjimjim]

I currently have this query:



$query = "SELECT * FROM stock WHERE model LIKE '%".$search."%'";


But what I also would like to do is search using two variables i.e

SELECT * from stock WHERE model LIKE $search1 BUT ALSO WHERE make LIKE $search2


Hope this makes sense!

Whats the correct PHP/MySQL for this query?

[bwh2]

$query = "SELECT * FROM stock WHERE model LIKE '%".$search."%' AND make LIKE '%".$search2."'";