<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > I use "SELECT DISTINCT tip, marca, model FROM modele" to select > records without duplicates on the field "tip". This works ok, BUT if I > use "SELECT DISTINCT tip, marca, model, id FROM..." (id is > auto_increment and is the table's primary key) my query won't produce > any result. ANyone has a clue? Thank you!
DISTINCT is ment for the total ressult, not for 1 field maybe try "GROUP BY tip" for a better result. > > Best regards, > Marius Panaitescu -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php