fetch row DISTINCT
| From: | Lars Hilsebein | Date: | Thu, 08 Jul 2004 17:25:50 +0000 |
| Subject: | fetch row DISTINCT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35151@lists.php.net to get a copy of this message | ||
I'm using PHP with mySQL since a long time.
But now I got a question:
I need to generate a SQL-Statement to fetch rows with one DISTINCT criteria.
To make things clear: I don't want to fetch a single DISTINCT column, I want
to fetch the whole row, where one column is DISTINCT.
Can someone explain me how to do this?
Kind regards
Lars Hilsebein
______________________________
<mailto:lars.hilsebein@mockandmore.de>
lars.hilsebein@mockandmore.de
------------------------------
mock&more i-net-solutions(r)
Horstmarer Landweg 107
D-48149 Muenster
Tel. +49 251 14490-200
Durchwahl 14490-201
Fax 14490-240
mobil +49 177 3295900
Mail info@mockandmore.de <mailto:info@mockandmore.de>
==============================