I assume you are trying to access a database randomly, I would process the mainweight randmom number then look for it... so, I'd order by whatever you want and WHERE mainweight = some var that contains the mainweight I calculated I need.
Weighted random SQL query
Miscellaneous Forums/General Discussion/Weighted random SQL queryThe forum is locked. These are the original blitzbasic.com forums, kept so they can still be read. No new topics, replies or edits can be made here. To join in, head over to the Blitz3D+ forums.