How can I write a PHP/MySQL script that pulls up as many banners on a webpage as I want by sponsor position. Jim was sponsored by Bob and has to click each banner to get in the program. In other words:
Bob was sponsored by
Sally who was sponsored by
Fred who was sponsored by
Jack who was sponsored by
In effect, I'm pulling up his upline's banners for the webpage.
I want 12 banners to a page, so, I need to pull up 7 more banners for my webpage from a database and then put them at the bottom of the line in that database so new banners get pulled up next time.
I also want to record the clicks for Jim and for the people who's banners are clicked.