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]

Reply via email to