filter the results of a database search based on choices from multiple select list

[Max58kl]

I have a select list that allows me to filter the results of a database search.
The user chooses from a dropdown menu then clicks submit.
The target page shows only the records containing what was chosen from the list.
What I would like is to allow the user to choose multiple items from the
list while holding down the ctrl key, then filter the search results based on what was chosen.
I tried simply adding multiple to the select form tag.
The reults still filtered according to only one of the options chosen.

This is my select code -

<select name="softwareLevel" id="softwareLevel">
        <?php
do {  
?>
        <option value="<?php echo $row_rs_level['level_id']?>"><?php echo $row_rs_level['level']?></option>
        <?php
} while ($row_rs_level = mysql_fetch_assoc($rs_level));
  $rows = mysql_num_rows($rs_level);
  if($rows > 0) {
      mysql_data_seek($rs_level, 0);
      $row_rs_level = mysql_fetch_assoc($rs_level);
  }
?>
      </select>
 

This is the code on my target page -

$query_rsTitles = "SELECT id, title, company, `description`, resources, location, url, image, keyword, copies FROM titles WHERE titles.level_id = ". GetSQLValueString($_POST['softwareLevel'], "int") ." ORDER BY id ASC";
}

[Dormilich]

to retrieve more than one value, rename the select to "softwareLevel[]" so that the values don’t overwrite each other.

then you have to rewrite your query to allow multiple input. like WHERE titles.level_id IN (1,2,3,4). consult the MySQL Manual for the exact syntax or ask in the MySQL forum.