adban.php Code


<HTML><HEAD>
<!-- 
PHP/MySQL Based Random Ad Banner Rotator
Version 3.0
adban.php
By Mike Calabrese
http://www.mikecalabrese.com/index.shtml
01-27-2005
-->
<TITLE>PHP/MySQL Based Random Ad Banner Rotator</TITLE>
</HEAD>
<BODY BGCOLOR="#ffffff" LINK="#008000" TEXT=#"000000" VLINK="#804000">
<CENTER>
<P>
<?
$link = mysql_connect ("localhost", "mikecalabrese", "mikesql")
or exit ();
mysql_select_db ("miketest")
or exit ();
$query = "select count(reference_number) from adban468";
$result = mysql_query ($query)
or exit ();
$row = mysql_fetch_row($result);
mysql_close ($link);
$reference_number = intval($row[0]);
$max_reference_number = rand(1,$reference_number);
$link = mysql_connect ("localhost", "yourlogin", "yourpassword")
or exit ();
mysql_select_db ("yourdatabase")
or exit ();
$query = "select ad_banner from adban468
where reference_number = $max_reference_number";
$result = mysql_query ($query)
or exit ();
$row = mysql_fetch_object($result);
mysql_close ($link);
?> 

<?
echo($row->ad_banner);
?>
<P> 
Your HTML would go here.
<P>
</BODY></HTML>