> 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
