Hi everyone,
This is a php and mysql question...
Advertising
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]
