AW: [PHP-DB] fetch row DISTINCT
| From: | Lars Hilsebein | Date: | Thu, 08 Jul 2004 18:10:37 +0000 |
| Subject: | AW: [PHP-DB] fetch row DISTINCT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35155@lists.php.net to get a copy of this message | ||
Sorry, but it's not truly what I am searching for:
The result is not unique.
What I mean is: every entry in the distinct_col should only be delivered
once.
As it would happen when I do the query "SELECT DISTINCT distinct_col FROM
table".
But I need to fetch the whole row.
Lars
-----Ursprüngliche Nachricht-----
Von: jeffrey_n_Dyke@Keane.com [mailto:jeffrey_n_Dyke@Keane.com]
Gesendet: Donnerstag, 8. Juli 2004 19:36
An: Lars Hilsebein
Cc: 'php-db@lists.php.net'
Betreff: Re: [PHP-DB] fetch row DISTINCT
> 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?
if i understand correctly this should work
--> select * from table group by distinct_col
hth
jeff
> 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>
==============================