[SOLVED] Early morning confusion...

[AV1611]

I have a table with this schema:

 

idx  name    ip

 

data is like this:

 

1    john  1.1.1.1

2  fred    2.2.2.2

3  john    1.1.1.1

4  john    2.3.3.4

 

etc.

 

 

The point being that there are many duplicated of name/ip pairs.

 

This query is SUPPOSED to grab the last 100 distinct names from the list, (for a pulldown list) but doesn't:

Select distinct `name` from table order by `idx` desc;

 

What am I missing?  It gives 100 names, but they are not the last on the list...

[AV1611]

Sorry to waste your time.  Two more sips of coffee revealed that I forgot to put limit 100 at the end, so I actually had the full list, not the last 100

Doh!