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@xxxxxxxxx [mailto:jeffrey_n_Dyke@xxxxxxxxx] Gesendet: Donnerstag, 8. Juli 2004 19:36 An: Lars Hilsebein Cc: 'php-db@xxxxxxxxxxxxx' Betreff: Re: 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@xxxxxxxxxxxxxx> lars.hilsebein@xxxxxxxxxxxxxx ------------------------------ 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@xxxxxxxxxxxxxx <mailto:info@xxxxxxxxxxxxxx> ============================== -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
