[PHP-DB] Multiple select list box to search mysql database

2002-01-01 Thread Gisele Grenier
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

Re: [PHP-DB] Multiple select list box to search mysql database

2002-01-01 Thread Bogdan Stancescu
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

Re: [PHP-DB] Multiple select list box to search mysql database

2002-01-01 Thread Bogdan Stancescu
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