Re: Quick MySql Question
| From: | Taylor York | Date: | Mon, 21 Oct 2002 22:35:47 +0000 |
| Subject: | Re: Quick MySql Question | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-120813@lists.php.net to get a copy of this message | ||
Well, I'm wanting one per group, so limiting will simly limit my amount of
results, not how many per group.
"Brad Bonkoski" <bbonkosk@tampabay.rr.com> wrote in message
news:3DB480A0.68FA991A@tampabay.rr.com...
> DOes it matter which one you get? If you want the first, look into useing
the
> LIMIT keyword in mysql. Otherwise using select off of a true unique
> identifier is always helpful :-)
> -Brad
>
> Taylor York wrote:
>
> > Hello, basically, I want a select with no duplicates...
> > I have a table similar to:
> > +----+--------+--------+
> > | id | model | make |
> > +----+--------+--------+
> > | 1 | Supra | Toyota |
> > +----+--------+--------+
> > | 2 | Civic | Honda |
> > +----+--------+--------+
> > | 3 | Celica | Toyota |
> > +----+--------+--------+
> > | 4 | Accord | Honda |
> > +----+--------+--------+
> >
> > If I do a " SELECT make FROM
table " I will get
> > 2 toyotas, and 2
hondas,
> > But what I want is just 1 toyota, and 1 honda.
> >
> > Any suggestions?
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>