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
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. I inherited the pipe-delimited data. I would > have done it as you suggested. > > Thanks. > > -Bob > > >>> "1LT John W. Holmes" <[EMAIL PROTECTED]> 0

Re: [PHP] php/mysql join query help

2002-05-23 Thread ROBERT MCPEAK
I appreciate you help. I inherited the pipe-delimited data. I would have done it as you suggested. Thanks. -Bob >>> "1LT John W. Holmes" <[EMAIL PROTECTED]> 05/23/02 01:57PM >>> It's generally a bad idea to store delimited data in a single column in a database. It kind of goes against what a

Re: [PHP] php/mysql join query help

2002-05-23 Thread 1LT John W. Holmes
It's generally a bad idea to store delimited data in a single column in a database. It kind of goes against what a database is there for. A better layout would be to have your second table contain a row for each of the "delimited" values. So if you have '1,2,3,4' in your database now, the better