Re: Quick MySql Question

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