[futureal]

I hit a roadblock tonight when I realized I had made an error in something I had said earlier, regarding the "Top Score Board." I had been using a GROUP BY clause in the SELECT query to get each user's top score. However, it came to my attention that in doing this, we are discarding all unique entries from other fields, and to make a long story short, the incorrect date/time/comments were coming back.

As far as that goes, I am left with a choice as to what to do. I can either:

(a) drop the entire idea of a top score board (I won't do this, though)
(b) add an additional query to the page for each user (server intensive, 25 users per page means an addition 25 queries)
(c) dump the entire table to an array in a second query and just use a search algorithm to find the correct values (might have major issues down the road if the table gets large enough)

What I will probably do is file this under the category of "known bug" and get back to it later, when I have the time to do a server-load test of options (b) and (c). In the meantime, if anybody knows MySQL extraordinarily well (in other words, you understand what I said in the first paragraph ) and has a good way of doing this efficiently, let me know.