0

I'm working on a simple advertisement script, I have a database with all the ads and a weight.

The ad is a picture and the weight is a number from 1 to 20 depending on it's importance (1 shows up rarely and 20 shows up a lot.

But if I'm getting this information from my database how do I sort and choose an ad to display? So can I put a weight on a variabele in a creative way? It's possible to make and array for each weight point and then select a random ad from that array but is there a better alternative?

Bart Scheffer
  • 497
  • 1
  • 3
  • 18

1 Answers1

1

@Dagon is correct. Use the example from that other question. Again Dagon found it here: MySQL: Select Random Entry, but Weight Towards Certain Entries The comments are really helpful. You basically multiple that row by its weight. To add to that question and answers I would add the rows into an array and then randomly pick one (one array value) to display. When something has more weight just place it in that array times its weight.

Community
  • 1
  • 1
Blizzardengle
  • 992
  • 1
  • 17
  • 30