2
[XOOPS 2.2.x]
SELECT COUNT(*) AS count, FROM_UNIXTIME(user_regdate,'%Y-%m-%d') AS date
FROM xoops_user_profile
WHERE user_regdate BETWEEN UNIX_TIMESTAMP('2005-11-01') AND UNIX_TIMESTAMP('2006-01-01')
GROUP BY date
ORDER BY count DESC
LIMIT 1
Replace "xoops" by your table prefix, and change the dates to the desired range.
If you're doing this manually, a query is ok.
If you're building it into XOOPS, it would be better to use the XoopsMemberHandler class, so that your code isn't dependent on the database structure.
