|
Posted by Joe on 01/07/06 23:00
Hi
I need some help doing a easy php/sql solution to a random selection with
rated stuff.
I have a table like:
Name Rated
--------------
Thompsen 500
Milla 10
Jensen 1
Means that the name Thompsen appears 50 times as often as Milla and 500
times as often Jensen.
I now need some scripting that counts the total ratefactor like
SELECT sum(Rated) FROM Table
In this case 511
And then make a random value between 1 and 511 and then print out the name,
which in this case will be Thompsen 500 of 511 times (in avg)
I need a quick way to find a name based on the Rated factors, any help?
Navigation:
[Reply to this message]
|