Dynamic, SQL Driven Image Rotator

Dear Friends,

I find myself in something of a pickle.

I need to make a dynamic ad rotator for a site I codded in PHP but i have limited space for the adds so i need a rotator that changes over time.

This is a usually done with javascript however all my ads are load from a custom SQL database. Curently my code looks like this

echo '<div class="adBox">';
$sponsoredquerry55 = mysql_query("SELECT * FROM AdLinkageDB WHERE ArticleID = '$AID'")or die(mysql_error());
while ($sponsoredquerryarr55=mysql_fetch_assoc($sponsoredquerry55)){
$AdsID = $sponsoredquerryarr55['AdsID'];
$sponsoredquerry6 = mysql_query("SELECT * FROM AdsDB WHERE AdsID = '$AdsID' AND Type = 3")or die(mysql_error());
while ($sponsoredquerryarr6=mysql_fetch_assoc($sponsoredquerry6)){
echo '<a href="'.$sponsoredquerryarr6['URL'].'">'.DynamicPicReturn($sponsoredquerryarr6['File']).'</a><BR>';
echo '<a href="#">'.DynamicPicReturn('dummy').'</a><BR>';
};//while
};//while
echo '</div>';

Code (markup):

AdsDB is the database where the physical ads are stored, add linkage DB is were the refresh code it, basicly one add could show up on multiple pages so the add linkage id conects a page ID to a Add id, grabs a array of all the Add IDS then displays those adds for that page.

But the problem is i need to restrict what it show to a set number of ads
then after X time it grabs the next batch of adds and dynamicy replaces them on the page without a page reload needed. ad infinitum.

i ca pull and dispay my ads fine but limiting the number and swithign them on the fly has me stumped.

as for my custom dynamic pic return function it replaces non existant images with a blank space and switces up between standard jpg.gif, etc and a flash file based on the filename it recieves

 

wow 2 days, 49 views and not a single inkling of a solution? Is my problem so complex?

i CAN mix java and PHP (as in my server supports it) i just not sure HOW for this situation