Using a listbox

[flouee]

Im using a listbox to decide what information from the database that should be printed at the page. If someone choose "Aes Sedai", every row with the ID = 1,4 or 8 should be printed, and the choice "gaidin" should print the rows with ID = 2,3 and 9.

Here's the listbox:

<select name="choice" id="choice" action="">
<option value="aessedai">Aes Sedai</option>
<option value="gaidin">Gaidin</option>
<option value="other">Andra</option>

And here's my SQL:

SELECT * FROM table WHERE ID = '$choice";

But how do I get this to work? I'm a newbie, so please try to explain in a way i can understand 🙂

[barand]

$choice = $_POST['choice'] ;

if ($choice == 'aessedai') 
    $list = '1,4,8' ;
elseif ($choice == 'gaidin')
    $list = '2,3,9' ;

$sql = "SELECT * FROM table WHERE id IN ($list) ";

hth