Results 1 to 1 of 1
Thread: top posters..
May 9, 2001, 17:39 #1
- Join Date
- Dec 2000
- Idaho, USA
- 0 Post(s)
- 0 Thread(s)
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...
Hope I'm being clear!
Thanks much for all the help and suggestions!!!
Alex StantonBlamestorming: Sitting around in a group discussing why a deadline was missed or a project failed and who was responsible.
Exbabylon- Professional Internet Services