Very odd. I would think it would return every record seeing as the auto_increment ID field is different for every record. >>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! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php