0 )){
mysql_select_db($database_BE2, $BE2);
$delete_SQL = sprintf("delete from ap2 WHERE adid='%s'",$_GET['del_id']);
$Rt2 = mysql_query($delete_SQL, $BE2) or die(mysql_error());
}
$webid=1;
if(isset($_GET['webid'])){
$webid=$_GET['webid'];
}
mysql_select_db($database_BE2, $BE2);
//$query_Rt2 = "SELECT a.*,b.* FROM ap1 as a ,ap2 as b left join adpic as c on b.adid=c.xid where a.raid=b.raid AND b.webid='$webid' order by b.raindex";
//$query_Rt2 = "SELECT a.*,b.*,count(c.xid) as xid FROM ap1 as a ,ap2 as b left join adpic as c on b.adid=c.xid where a.raid=b.raid AND b.webid='$webid' group by c.xid order by b.raindex";
//$query_Rt2 = "select a.*,b.*,c.* from adpage as a, ap2 as b,ap1 as c where a.pid=b.webid and b.raid=c.raid and webid='$webid' order by b.raindex";
$query_Rt2 = "SELECT a.*,b.*,c.*,COUNT(d.xid) as dd FROM adpage AS a,ap1 AS c,ap2 AS b LEFT JOIN adpic AS d ON d.xid = b.adid WHERE a.pid = b.webid AND b.raid = c.raid AND webid = '$webid' GROUP BY b.adid ORDER BY b.raindex";
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2 = mysql_num_rows($Rt2);
?>
