Adding continuing range then selecting a random number

[mishav]

Which solution fits best depends on how many users and listings, see discussion of a similar but simpler problem:

Get random value based on probabilities

HI everyone, my problem is that User table has field points ( type : number ) Option table contain who take part in ( list of users ) Vote table list of options and date that make voting expired i want to choose a random user when vote expired ( consider that each user has a probability to be chosen equal to number of point / all users point sum ) Example to simplify it : let A , B, C are users A → point = 10 A → point = 20 A → point = 30 Sum = 10 + 20 + 30 = 60 now probability of A (…