> 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:[EMAIL PROTECTED]> [EMAIL PROTECTED]
------------------------------
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 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
==============================
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
