Select * from wine where name = 'Silver Oak' GROUP BY wineid,size
bastien> Date: Wed, 6 Feb 2008 17:46:52 -0800> From: [EMAIL PROTECTED]> To:
php-general@lists.php.net> Subject: [PHP] PHP/mySQL question about groups> >
Let's say I have a PHP-based wine application, and it's taking a set of mySQL
data that looks like this:> > wineid name size > 123 Silver Oak 750ML> 123
Silver Oak 1.5L> 123 Silver Oak 1.5L> 456 Liberty School 750ML> 456 Liberty
School 750ML> 456 Liberty School 750ML> 456 Liberty School 1.5L> > > If I do
a:> > Select * from wine where name = 'Silver Oak' GROUP BY 'wineid'> > I'd
get:> > Silver Oak> > > However, what I'd REALLY like to return is:> > Silver
Oak 750ML> Silver Oak 1.5L> > I'd like the groupby to group by wineid, BUT ALSO
separate the groups by 'size'. So there'd be a '750ML' group, and a '1.5L'
group> > Can anyone tell me how I'd do that? I'm hoping I don't have to write a
PHP script that loops through the results and separates things manually.> > --
> PHP General Mailing List (http://www.php.net/)> To unsubscribe, visit:
http://www.php.net/unsub.php>
_________________________________________________________________
