The problem is > a f1 > a f2 > b f1 > b f2
Where I need it to return the a only once and the b only once. For instance the vlaues may be: jimmy login.php jimmy successfullogin.php susan default.php susan search.php Since the records are order the way I need them to be (or else I could use a ORDER BY command) the last one is the only one I want and only want to return: jimmy successfullogin.php susan search.php make sense? "Arturo Barajas" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Vernon, > > Don't know if I get it right, but: > > SELECT DISTINCT uname, file > FROM useronline > > should do that. > > I mean, if you have something like: > > uname file > a f1 > a f2 > a f1 > a f2 > b f1 > b f2 > b f1 > > the query should deliver: > > uname file > a f1 > a f2 > b f1 > b f2 > > Is that what you're looking for? > -- > Un gran saludo/Big regards... > Arturo Barajas, IT/Systems PPG MX (SJDR) > (427) 271-9918, x448 > > > -----Original Message----- > > From: Vernon [mailto:[EMAIL PROTECTED] > > Sent: Jueves, 13 de Marzo de 2003 06:24 p.m. > > To: [EMAIL PROTECTED] > > Subject: [PHP] SQL DISTINCT with MYSQL > > > > > > I'm setting up a user online system using MySQL where I have > > 4 fields, all > > of which is working fine. > > > > I need the information from all the fields but want only > > distinct values > > based on the uname column. If I use the: > > > > SELECT DISTINCT uname > > FROM useronline > > > > of course I come back with the values I desire, but only the > > user names. > > > > As I am also tracking the page they are on I need other > > columns in the table > > as well. So the question is, using an SQL statement, how do I > > return only > > distinct useronline.uname values from the database as well as the > > useronline.file column? > > > > Thanks > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
