There may be a much simpler way:
For each ad, just have 1 field that specifies what % that ad should have.
Whenever you add / edit an ad (maybe use a trigger), have it then fill in
(or update) 2 more fields, call it N1 and N2, with the numbers from 0 to
100 which represent that fraction they should get.. for example:
Ad title Percent N1 N2
Ad1 20 0 20
Ad2 50 20 70
ad3 30 70 100
Now just generate a random number , R, from 0 to 100.
Look for the ad where R is between N1 and N2
I did something like that, and the ads come out remarkably close to the
predicted frequency!
Al Musella
World Wide Websites
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
