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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 8. Juli 2004 19:36 An: Lars Hilsebein Cc: '[EMAIL PROTECTED]' 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:[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
