Re: PHP/mySQL question about groups

["Nathan Nobbe" <quickshiftin@xxxxxxxxx>]

On Feb 6, 2008 8:46 PM, Rob Gould <gouldimg@xxxxxxx> wrote:

> 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
>

i think you can just do

group by wineid, size

-nathan