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());
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form_ad2set")) {
$insertSQL = sprintf("INSERT INTO adpage (pdoc,pdata,pindex,pmid) VALUES ( %s, %s, %s, %s)",
GetSQLValueString($_POST['pdoc'], "text"),
GetSQLValueString($_POST['pdata'], "text"),
GetSQLValueString($_POST['pindex'], "int"),
GetSQLValueString($_POST['pmid'], "int"));
echo $insertSQL;
mysql_select_db($database_BE2, $BE2);
$Result1 = mysql_query($insertSQL, $BE2) or die(mysql_error());
// $insertGoTo = $_POST['url'];
// header(sprintf("Location: %s", $insertGoTo));
}
//$webid=1;
//if(isset($_GET['webid'])){
// $webid=$_GET['webid'];
// }
$colname_Rt3 = "-1";
if (isset($_GET['mid'])) {
$colname_Rt3 = $_GET['mid'];
}
$progam_arr1=array("login.html","register.html","contact.html");
if(! in_array( $rt3link,$progam_arr1) ){
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 a.pmid = '$colname_Rt3' GROUP BY b.adid ORDER BY b.raindex" ;
$query_Rt2 = "SELECT a.*,b.*,c.*,COUNT(d.xid) as dd FROM adpage AS a left join ap2 AS b on a.pid = b.webid left join ap1 AS c on b.raid = c.raid LEFT JOIN adpic AS d ON d.xid = b.adid WHERE a.pmid = '$colname_Rt3' 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);
// echo $query_Rt2." ";
if($totalRows_Rt2>0){
?>
新增廣告區塊
'.$query_Rt2; }?>
ID
廣告區塊
廣告圖檔說明
廣告說明
顯示BANNER
ICON
使用
物件標題
排列
圖數
編輯
刪除
0){
do {
// check recno is set
if($row_Rt2['webid']>0){
?>
