Re: mysql - SELECT DISTINCT problem
| From: | Daniel Clark | Date: | Sat, 08 May 2004 17:22:40 +0000 |
| Subject: | Re: mysql - SELECT DISTINCT problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34314@lists.php.net to get a copy of this message | ||
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!