most efficient weighting system? URGENT
| From: | Noah Spitzer-Williams | Date: | Fri, 29 Jun 2001 19:44:31 +0000 |
| Subject: | most efficient weighting system? URGENT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9979@lists.php.net to get a copy of this message | ||
if i have several rows in a table and i want some to have certain weights
what is the best way to pick a random row based on its weight?
ex of table:
id weight
1 10
2 5
3 3
4 20
5 2
therefore, since there is a total weight of 40, id 1 should be picked 25%
(10/40) of the time, id 4 50% (20/40), etc...
what is the best way to do this?
- Noah