Original
Message
Date: 25-May-02 @ 12:13 PM -
++chartvote updated++
k
Posts: 12353
Link?: Link
File?: No file
ok ahem... you'll notice the frontpage chart has suddenly changed a bit, i fixed it - sorry it took time, but other stuff has been more important... anyways i sat down this morning with a a quality bazooka and spent a few hours trying to re-write the query & cracked it finaly by luck - it was a very complicated sql query for me at least anyways - to join 3 tables, count & total the totalvotes per listed unique track_id but only within a certain date range & group all included output columns ordered by counted totalvotes per id number... g-gulp!
anyways it's sorted & yes, KIKI is still at the top, but that is because it IS actualy getting regular votes every day, but without giving away the figures it'll only take a few extra votes cast for one of it's challengers to knock it off the top now.
___________________________________
I had an idea for a script once. It's basically Jaws except when the guys in the boat are going after Jaws, they look around and there's an even bigger Jaws. The guys have to team up with Jaws to get Bigger Jaws.... I call it... Big Jaws!!!