<mariuspa@xxxxxxxxxxxx> wrote in message news:227796879.20040508173929@xxxxxxxxxxxxxxx > 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
