RE: [PHP] Looking for a little MySQL help as well

2010-07-12 Thread Tommy Pham
> -Original Message- > From: Jim Lucas [mailto:li...@cmsws.com] > Sent: Monday, July 12, 2010 3:51 PM > To: Phillip Baker > Cc: PHP General List > Subject: Re: [PHP] Looking for a little MySQL help as well > > Jim Lucas wrote: > > Phillip Baker wrote: &

Re: [PHP] Looking for a little MySQL help as well

2010-07-12 Thread Jim Lucas
Jim Lucas wrote: > Phillip Baker wrote: >> Thanks Jim, >> >> This outputs 2 results. >> Is there a way to get the one result set per product regardless of the >> number of categories associated with the product, yet displaying all the >> categories associated with said prodcut? > > Run this: > >

Re: [PHP] Looking for a little MySQL help as well

2010-07-12 Thread Jim Lucas
Phillip Baker wrote: > Thanks Jim, > > This outputs 2 results. > Is there a way to get the one result set per product regardless of the > number of categories associated with the product, yet displaying all the > categories associated with said prodcut? Run this: SELECT p.Product_Name, GROUP

RE: [PHP] Looking for a little MySQL help as well

2010-07-12 Thread Tommy Pham
From: Phillip Baker [mailto:phil...@freewolf.net] Sent: Monday, July 12, 2010 1:33 PM To: Tommy Pham Cc: PHP General List Subject: Re: [PHP] Looking for a little MySQL help as well Thanks Tommy, Damn. I was hoping to avoid that and get all the information in one query rather than running a ton

Re: [PHP] Looking for a little MySQL help as well

2010-07-12 Thread Phillip Baker
: PHP General List > > Subject: Re: [PHP] Looking for a little MySQL help as well > > > > Thanks Jim, > > > > This outputs 2 results. > > Is there a way to get the one result set per product regardless of the > number > > of categories associated wit

RE: [PHP] Looking for a little MySQL help as well

2010-07-12 Thread Tommy Pham
> -Original Message- > From: Phillip Baker [mailto:phil...@freewolf.net] > Sent: Monday, July 12, 2010 11:36 AM > To: Jim Lucas > Cc: PHP General List > Subject: Re: [PHP] Looking for a little MySQL help as well > > Thanks Jim, > > This outputs 2 results. &

Re: [PHP] Looking for a little MySQL help as well

2010-07-12 Thread Phillip Baker
Thanks Jim, This outputs 2 results. Is there a way to get the one result set per product regardless of the number of categories associated with the product, yet displaying all the categories associated with said prodcut? Blessed Be Phillip If you try to protect idiots from themselves, even if y

Re: [PHP] Looking for a little MySQL help as well

2010-07-12 Thread Jim Lucas
Phillip Baker wrote: > Hey All, > > I am looking for a little MySQL Query help as well. > I am not getting any response form the MySQl Email list to my query. > And knowing there are some SQL wizards on this list I thought I would as for > help as well. > > I have one table with products that man

[PHP] Looking for a little MySQL help as well

2010-07-12 Thread Phillip Baker
Hey All, I am looking for a little MySQL Query help as well. I am not getting any response form the MySQl Email list to my query. And knowing there are some SQL wizards on this list I thought I would as for help as well. I have one table with products that many have one or more categories. I am u