<?

mysql_connect("localhost", "ldifiore", "sillyputty");

$today=date("Y-m-d");

$kresult=@mysql("freschinfo", "select * from adrotate where codenumber='$codenumber'");
$website=@mysql_result($kresult, $counter, "website");
$advertiser=@mysql_result($kresult, $counter, "advertiser");
$notes=@mysql_result($kresult, $counter, "notes");

/* check to see if there is an entry in the statistics table */

$nresult=@mysql_db_query("freschinfo", "SELECT impressions, clicks from adstats where codenumber='$codenumber' and whatdate='$today'");

$total_rows=@mysql_numrows($nresult);

/* if there isn't, then create one */

if ($total_rows <1):

mysql_db_query("freschinfo", "insert into adstats values ('$codenumber', '$advertiser', curdate(), '1', '0', '$notes')");

endif;

/* if there is, then update impressions */

if ($total_rows > 0 && $state != "click"):


mysql_db_query("freschinfo", "UPDATE adstats SET impressions=impressions+1 WHERE (codenumber='$codenumber' and whatdate='$today')");

endif;

/* if clicked on, update the clicks and relocate to the proper website */

if ($state="click"):


mysql_db_query("freschinfo", "update adstats set clicks=clicks+1 where whatdate='$today' and codenumber='$codenumber'");


header ("Location: $website\n\n");

endif;

?>