Hi everyone,
This is a php and mysql question...
I've spent days trying to figure this out and can only find help on one or
the other.. not both things that I'm trying to do.
I have a table called inventory which contains the following:
manufacturer
product
price
I have a php form that has a list box that contains distinct values from the
inventory table as follows:
$sql = "SELECT DISTINCT MANUFACTURER FROM inventory ORDER BY MANUFACTURER
ASC";
// execute SQL query and get result
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");
// put data into drop-down list box
while ($row = mysql_fetch_array($sql_result)) {
$manufacturername = $row["MANUFACTURER"];
$option_block.= "<OPTION
value=\"$manufacturername\">$manufacturername</OPTION>";
}
Then the list box is created:
Select a manufacturer
<SELECT name="manufacturername">
<option>All</option>
<? echo "$option_block"; ?>
</SELECT>
All this works great when selecting only one manufacturer to display. The
data is passed to: $query .= "WHERE MANUFACTURER LIKE '$manufacturername'
Where I'm having a problem is that I want to be able to select multiple
manufacturers to search.
I know that I need to add multple to the select as:
<SELECT name="manufacturername" multiple>
and that's about it...I'm lost after this.
can anyone shed any light on this?
Thanks,
Gisele Grenier
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
