File size: 916B
<html>
<title>Advertising History</title>
<?php include "inc/def.php"; ?>
<?php include "inc/usrchk.php";
if($guest==1) {
header("location:index.php");
} ?>
<?php include "inc/header.php"; ?>
<div class="line">Advertising History</div>
<?php
$getu = mysql_query("SELECT * FROM users WHERE user='$user'");
$getu1 = mysql_fetch_array($getu);
$id = $getu1['id'];
$get=mysql_query("SELECT * FROM comp WHERE uid='$id'");
while($comp=mysql_fetch_array($get)) {
$cid = $comp['id'];
$name = $comp['title'];
$getimp = mysql_query("SELECT * FROM imp WHERE compid='$cid'");
$imp = mysql_num_rows($getimp);
$getclk = mysql_query("SELECT * FROM clicks WHERE compid='$cid'");
$clk = mysql_num_rows($getclk);
print "<div class='lgn'><B>Title : $name</B></div>";
print "<div class='lwt'>Total Impressions : $imp</div>";
print "<div class='lwt'>Total Clicks : $clk</div>";
}
?>
<?php include "inc/footer.php"; ?>
</html>