argh! Help needed!

[Pr0ject]

I have 3 drop down fields that will allow my users to select ANY or ALL, then upon submit they results will get displayed.

I need to figure out how the backend will handle the selections a user chooses...

So far, I have this which works so long as only ONE option is selected. It seems all i need now is a way to include an AND statement if more than one option is selected.

$sql = "SELECT * FROM present";
if (($type != "&quot || ($price != "&quot || ($state != "&quot) $sql .= " WHERE ";
if (($type != "&quot) $sql .= "Type = '$type' ";
if (($price != "&quot) $sql .= "Price $price ";
if (($state !="" )) $sql .= "Location = '$state' ";

Any suggestions? Give me a hollar at pr0ject-at-reject.org.

Thanks.

 

[enterume]

try to put array name for the selector, like <select name=var[]>

if the user choose multiple selection, it will save in array when submit the form.


Thanks
Louis