<[EMAIL PROTECTED]> wrote in message
> 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

Reply via email to