Is that right what I did?

[npsari]

Is this ok...

 

$result = mysql_query("SELECT * FROM Table Where Color=Red OR Blue");

 

I want the code to display both Red Or Blue

 

is that the way to do it guys?

[fert]

$result = mysql_query("SELECT * FROM Table Where Color='Red' OR Color='Blue'");

[npsari]

Ohh, thanks

 

My code will is like that...

 

$result = mysql_query("SELECT * FROM Table Where Color=$Color");

 

I dont know what value to give 'Both' to make it display Red & Blue

 

<select name="Color" size="1">

<option value="Red">Red</option>

<option value="Blue">Blue</option>

<option value="??">Both</option>

</select>

 

Any ideas