Quick question, I have a table of messages each with a timestamp and a reply_id and a topic_id. Reply_ids can be the same as others, which means those messages are in the same group of replies. When I
Using MySQL and PHP, I have a simple ranking table with 2 columns user and score. Once a week, I re-run the ranking script and it computes scores for each user.
For student council this year, I\'m on the \"songs\" committee, we pick the songs. Unfortunately, the kids at the dances always end up hating some of the stupid song choices. I thought I could make it
I have written the following query so as to select the rank of each customer and show it with other information in the output.
i have a trivia game and i want to reward users for 2 events: 1) answering correctly 2) sending a question to the questions pool
I need to compare 2 strings and calculate their similarity, to filter down a list of the most similar strings.
Is there a simpler/cleaner way to do this using SQL Server 2000? Every few days I need to do this. I first look at how many records we have total:
I could really use some help optimizing a table on my website that is used to display rankings. I have been reading a lot on how to optimizequeries and how to properly use indexes but even after imple
What I mean by bandwagon effect describes itself like so: Already top-ranked items have a higher tendency to get voted on at all, possibly even to get upvoted.
Say I wa开发者_运维知识库nt to get ten records with the MOST likes in the last 24 hours. Here\'s what I have so far:
加载中,请稍侯......