this query not working...

[mysticav]

Well basically, what I want is this:

select distinct ip, id, product, file, timestamp from useronline order by id desc...

Doind this, I will get duplicate results from IP. distnct is ignored..

example:
----IP------ ---PRORDUCT---
192.168.1.115 bannana
192.168.1.115 apple
192.168.1.110 pear
192.168.1.110 orange

LEts say, I want to get distinct result from IP.. only show one ip of both, and those results ordered by alphabetic asc:

I should get only this rows :

192.168.1.110 apple
192.168.1.115 orange

I already tried this:

select ip, id, product, file, timestamp
from useronline
group By IP
order By ID DESC

Any Ideas ???

[Lars_Berg]

select ip,min(product) 
from useronline
group by ip

distnct is ignored..

It's not. Distinct is applied to all columns.

[mysticav]

this is the solution (compatible with MySQL 4.0):

$query="select curly.ip
     , curly.product    

     , curly.file
     , curly.timestamp 
  from useronline as curly
inner
  join useronline as larry
    on curly.ip 
     = larry.ip 
group
    by curly.ip
     , curly.product
     , curly.file
     , curly.timestamp 
having curly.timestamp
     = max(larry.timestamp)";

and MySQL 4.1 version and ++ :

$query="SELECT timestamp, ip, product FROM (SELECT timestamp, ip, product FROM useronline ORDER BY timestamp DESC) AS customers GROUP BY ip";

I hope ths help others.