0 )){
mysql_select_db($database_BE2, $BE2);
$delete_SQL = sprintf("delete from adpage WHERE pid='%s'",$_GET['del_id']);
$Rt2 = mysql_query($delete_SQL, $BE2) or die(mysql_error());
}
$colname_Rt2 = "-1";
if (isset($_GET['keyword']) && $_GET['keyword']<>'') {
$colname_Rt2 = '1';
}
mysql_select_db($database_BE2, $BE2);
$sql=" AND a.pdata<>'P' ";
if($myadmin){$sql=""; }
if ($colname_Rt2=='-1') { $query_Rt2 = "SELECT a.*,b.sgid FROM adpage as a left join signup1 as b on a.pid=b.spid where a.pmid=0 order by pindex";}else{
if($_GET['rkey']=='1'){
$ss=sprintf("AND pdoc like '%s' order by pindex",'%'.trim($_GET['keyword']).'%');
}else{ $ss=sprintf("AND plink like '%s' order by pindex",'%'.trim($_GET['keyword']).'%'); }
$query_Rt2 = sprintf("SELECT a.*,b.sgid FROM adpage as a left join signup1 as b on a.pid=b.spid where a.pmid=0 %s ",$ss);
// echo $query_Rt2;
}
//$query_Rt2 = "SELECT * FROM adpage where pmid=0 $sql order by pindex";
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2 = mysql_num_rows($Rt2);
?>
| ID |
廣告分頁說明 |
廣告分頁連結 |
廣告區塊設製 |
報名表 |
排列序 |
刪除 |
0){
do { ?>
 |
|
|
|
|
|
 |