[SOLVED] searching query

[phpSensei]

I have two fields in my form, One is Genre (Menu/List) Of The Movie, and the other is the search field.

 

In my database, the list of movies have a genre row, showing which genre they belong two.

 

300 - Action

Simpsons Movie - Comedy...

 

The Menu/list field lets you choose the genre...

 

So is this query right?

 

<?php
$select=$_POST['genre'];

$data = mysql_query("SELECT * FROM list WHERE id_genre='$select' upper(title) LIKE'%$find%'"); 
?>

[Barand]

It needs to be either

 

$data = mysql_query("SELECT * FROM list WHERE (id_genre='$select') AND (upper(title) LIKE '%$find%') ");

 

or

 

$data = mysql_query("SELECT * FROM list WHERE (id_genre='$select') OR (upper(title) LIKE '%$find%') ");

 

which one you use depends on what you want to find

 

 

[phpSensei]

thanks,

 

Topic Solved.