RE: [PHP] SQL DISTINCT with MYSQL

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:vernon@comp-wiz.com] > Sent: Jueves, 13 de Marzo de 2003 06:24 p.m. > To: php-general@lists.php.net > 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 >