Ratios in Queries

[CFProgrammer]

I am building a banner ad management system. But I would like to use ratios in my queries. Meaning I would like banner x to display 20:1 (twenty-to-1) or banner y display 5:1. How would I do this with?

Thanks for all your support!

 

[jhall156]

Are you saying you want to return a value to a variable that contains ratio text based on a mathematical ratio? JHall

 

[CFProgrammer]

I guess. Whatever you think? I am totally lost on this one.

Thanks

 

[jhall156]

Need more details. JHall

 

[CFProgrammer]

Ok,
Let's say you have 10 products in a table, and you query the table,

select *
from productTable

Now: I would like product "1" to be display 5 time more likely than product 2-10.

Thanks all I know. I appreciate everything though.