> -----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.
> Is there a way to get the one result set per product regardless of the
> of categories associated with the product, yet displaying all the
> associated with said prodcut?
> Blessed Be
> Phillip


What you're asking for requires the use of (IIRC) 'cursors'.  I don't know
if MySQL's meaning/usage of 'cursors' is the same as MSSQL.  Either way,
you'll need to write some serious (read pain in the a**) Stored Procedure
(SP).  You're better off implementing that in PHP loop containing 'if' since
you're not a DBA ;).


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to