Wow! It's been a long time since I've been keeping up here! Got a lot of reading to do it looks like!

Well, I hope to be some help to other again, but for right now I'm back to asking stupid questions again!

What I'm trying to do is to create a contest... I have two tables and each holds a different type of data posted by each user. I have a user database, and what I need to do is to go through my user database, count the number of posts by each user, and, in the end, display the, say, top 10 users sorted by number of posts. This would be easy enough (I think) but I also have to sort these by, say the number of posts since 05-01-01... having a contest for the most number of posts in a certain date period.

Any ideas or code to get me started?

Here is an example of my tabe layout...

[code]
Data1
ID
date
username
blah
foo

Data2
ID
date
username
blah
foo

Users
ID
username
password
email
comments

Hope I'm being clear!

Thanks much for all the help and suggestions!!!

Alex Stanton