I am trying to rotate adds that are from tradedoubler !!
I have created a mysql db as follows
and i can succesfully connect via a php include and rotate my query to show a different add each time the page loads
$sql = mysql_query("SELECT * FROM table ORDER BY RAND() LIMIT 0, 1");
The problem im having is that add itself is not showing,
Im new to php, but im learning each day new coding skills.
Is there anyone here that could help with successfully calling a java script from a mysql database.
The format of the add from TD is as follows
var uri = 'http://impgb.tradedoubler.com/imp?type(img)g(88888888)a(88888888)' + new String (Math.random()).substring (2, 11);
document.write('<a href="http://clkuk.tradedoubler.com/click?p=18710&a=88888888&g=88888888" target="_BLANK"><img src="'+uri+'" border=0></a>');
I have tried using just the 'http://impgb.tradedoubler.com/imp?type(img)g(88888888)a(88888888)
if anyone could point me in the right direction and help me enhance my programming skills,