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
In HTML:
SELECT name=manufacturernames[] multiple
(note the name has PHP-like array definition)
In PHP:
for ($i=0;$isizeOf($manufacturernames);$i++) {
if ($i==0) {
$q_cond=where;
} else {
$q_cond=or;
}
$query.=$q_cond MANUFACTURER LIKE '$manufacturernames[$i]';
}
Gisele Grenier
Bogdan Stancescu wrote:
In HTML:
SELECT name=manufacturernames[] multiple
(note the name has PHP-like array definition)
In PHP:
for ($i=0;$isizeOf($manufacturernames);$i++) {
if ($i==0) {
$q_cond=where;
} else {
$q_cond=or;
}
$query.=$q_cond MANUFACTURER LIKE