 |
 |
 |
 |
|
|
php-db | 2004071
Date: 07/08/04
- Next message: John Van Vranken: "[PHP-DB] Query: Top 3 Results grouped by Category"
- Previous message: Michael Gale: "Re: [PHP-DB] Storing Date in mysql"
- Maybe in reply to: Lars Hilsebein: "[PHP-DB] fetch row DISTINCT"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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 <email protected>> lars.hilsebein <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 info <email protected> <mailto:info <email protected>>
==============================
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
- Next message: John Van Vranken: "[PHP-DB] Query: Top 3 Results grouped by Category"
- Previous message: Michael Gale: "Re: [PHP-DB] Storing Date in mysql"
- Maybe in reply to: Lars Hilsebein: "[PHP-DB] fetch row DISTINCT"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
