RE: [PHP] SQL DISTINCT with MYSQL

AND useronline.atime=tmp.atime You can index on atime field for faster results. hope it helps... regards, -Original Message- From: Vernon [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 06:20 To: [EMAIL PROTECTED] Subject: Re: [PHP] SQL DISTINCT with MYSQL The problem is a f1

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

Re: [PHP] SQL DISTINCT with MYSQL

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