|
|
$sql = "SELECT * FROM banner where position='slide' and status=0";
$sql .= " order by id desc limit 0,30";
$result = mysql_query($sql);
while($rowbanner = mysql_fetch_array($result)){
?>
-
/*$sql = "SELECT * FROM bannerstat where bannerid='".$rowbanner['id']."' and year='".date('Y')."' and month='".date('m')."' and day='".date('d')."' and hour='".date('H')."'";
$result2 = mysql_query($sql);
$rowbannerstat = mysql_fetch_array($result2);
if($rowbannerstat['bannerid']){
$sql = " UPDATE bannerstat SET
pageview =".($rowbannerstat['pageview'] + 1)."
where bannerid='".$rowbanner['id']."' and year='".date('Y')."' and month='".date('m')."' and day='".date('d')."' and hour='".date('H')."'";
mysql_query($sql);
}else{
$sql = "INSERT INTO bannerstat(bannerid, year, month, day, hour, pageview, click) VALUES('".$rowbanner['id']."','".date('Y')."','".date('m')."','".date('d')."','".date('H')."',1,0)";
mysql_query($sql);
}*/
?>
} ?>
|
|
|