Hi

  First, unless there is a compelling reason not to, I'd suggest you use
a single date field, instead of separate year, month, day columns.  It
will be much more efficient on space and indexes.

Then, based on your own query, use:
 SELECT DISTINCT ip, date FROM tracker WHERE page = 'index' ORDER BY
date DESC LIMIT 0,20

Niel

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to