Do you have a question? Post it now! No Registration Necessary. Now with pictures!
January 31, 2005, 11:09 pm
rate this thread
to count repititions in table:
SELECT COUNT( userid ) AS repetitions, userid FROM `table`
GROUP BY userid
ORDER BY repetitions DESC
This would return a list of distinct userids and the number of times each
userid appeared in the table, in descending order.