uname 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
&
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
O
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
3 matches
Mail list logo
