RE: [PHP] php/mysql join query help

2002-05-23 Thread John Holmes
Sent: Thursday, May 23, 2002 3:06 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] php/mysql join query help > > The sooner you fix it, the less work you have to do down the road! > > miguel > > On Thu, 23 May 2002, ROBERT MCPEAK wrote: > > > I appreciate you help.

Re: [PHP] php/mysql join query help

2002-05-23 Thread Miguel Cruz
key > per row in table2. If a row has 'blue' twice, only one will be > counted. > > ---John Holmes... > > - Original Message - > From: "ROBERT MCPEAK" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, May 23, 2002

Re: [PHP] php/mysql join query help

2002-05-23 Thread ROBERT MCPEAK
key per row in table2. If a row has 'blue' twice, only one will be counted. ---John Holmes... - Original Message - From: "ROBERT MCPEAK" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 23, 2002 1:22 PM Subject: [PHP] php/mysql join query help

Re: [PHP] php/mysql join query help

2002-05-23 Thread 1LT John W. Holmes
But, the flaw of that is that it'll only count one occurance of table1.key per row in table2. If a row has 'blue' twice, only one will be counted. ---John Holmes... - Original Message - From: "ROBERT MCPEAK" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

[PHP] php/mysql join query help

2002-05-23 Thread ROBERT MCPEAK
I have a table with a field "key" containing a unique value. I have a second table containing a field called "keys" containg a pipe-delimited list of values from the "key" table. I'd like to do a query that took each value from key, and matched it agains the field "keys" in the second table, and