I can't figure out a query to get multiple selections from a list box to filter records in mysql. Below are sample files of my attempt. Any suggestions? Thanks.
================= form.php =================
<form action="results.php?search=true" method="get" name="form" target="_self" id="form">
<p>
<select name="fruits[]" size="5" multiple>
<option value="apples">Apples</option>
<option value="oranges">Oranges</option>
<option value="pears">Pears</option>
<option value="grapes">Grapes</option>
<option value="mangos">Mangos</option>
</select>
<br>
<input type="submit" name="Submit" value="Submit">
</form>
============================================
================= results.php =================
<?php
$foo = $_GET['fruits'];
if (count($foo) > 0) {
for ($i=0;$i<count($foo);$i++) {
echo "<li>$foo[$i] \n";
mysql_select_db($database_conn, $conn);
$query_Recordset1 = sprintf("SELECT * FROM test WHERE name LIKE '%%%s%%'", $foo[$i]);
$Recordset1 = mysql_query($query_Recordset1, $conn) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
}
}
?>
<html><head></head><body>
<table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>testID</td>
<td>name</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['testID']; ?></td>
<td><?php echo $row_Recordset1['name']; ?></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
</body>
</html>
<?php
?>
============================================