mysql - SELECT DISTINCT problem
| From: | mariuspa at softhome dot net | Date: | Sat, 08 May 2004 14:39:29 +0000 |
| Subject: | mysql - SELECT DISTINCT problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34308@lists.php.net to get a copy of this 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!
Best regards,
Marius Panaitescu