[PHP-DB] newbie: MySQL Problem or severe ignorance..

2002-01-01 Thread Chris Hogben
I've just been looking at this snippet, and wondering why it's not working.. Either i'm doing something wrong, or i'm just totally ignorant.. (More likely the latter). But if anyone can help me out, please let me know.. --- $query = SELECT * from counter; $result = mysql_query($query);

RE: [PHP-DB] newbie: MySQL Problem or severe ignorance..

2002-01-01 Thread rhelms
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Chris Hogben, I've just been looking at this snippet, and wondering why it's not working.. Either i'm doing something wrong, or i'm just totally ignorant.. (More likely the latter). But if anyone can help me out, please let me know.. ---

[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