Re: PHP/mySQL question about groups
| From: | Nathan Nobbe | Date: | Thu, 07 Feb 2008 01:57:10 +0000 |
| Subject: | Re: PHP/mySQL question about groups | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-268824@lists.php.net to get a copy of this message | ||
On Feb 6, 2008 8:46 PM, Rob Gould <gouldimg@mac.com> 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