RE: [PHP] SQL DISTINCT with MYSQL

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 &

Re: [PHP] SQL DISTINCT with MYSQL

gt; 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] > > Sen

RE: [PHP] SQL DISTINCT with MYSQL

e- > 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 f

[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 des