"; $updateSQL = "INSERT INTO storeadv (rid, aid, ind1, sdate1, edate1) VALUES "; for($i=0;$i<$_POST['ckcount'];$i++){ if (isset($_POST['ck'.$i])){ if($x>0){ $updateSQL .=",";} $updateSQL .= sprintf("('%s','%s','%s','%s','%s' )",$_POST['rid'],$_POST['ck'.$i],$_POST['ind'.$i],$_POST['sdate'.$i],$_POST['edate'.$i] ); $x++; } } if($x>0){ $updateSQL .=";"; mysql_select_db($database_BE2, $BE2); $Result1 = mysql_query($updateSQL, $BE2) or die(mysql_error()); // echo $updateSQL; } $updateGoTo = $_POST["url"]; header(sprintf("Location: %s", $updateGoTo)); } $bid=172; //商店專區 $rid=-1; if(isset($_POST['rid'])){$rid=$_POST['rid'] ;} else if(isset($_GET['rid'])){ $rid=$_GET['rid']; } mysql_select_db($database_BE2, $BE2); //$query_Rt2 = sprintf("select a.*,b.* from left join adpic WHERE xid='%s'",$bid); $query_Rt2 = sprintf("select c.*,d.* from adpage as a,ap2 as b,adpic as c left join storeadv as d on d.aid=c.id AND d.rid=%s WHERE b.adid=c.xid AND a.pid=b.webid AND b.adid='%s'",$rid,$bid); // echo $query_Rt2 ; $Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error()); $row_Rt2 = mysql_fetch_assoc($Rt2); $totalRows_Rt2 = mysql_num_rows($Rt2); ?> 商店專門頁

""){ $i=0; do { ?>

選取		圖片說明	圖檔	排列序	啟用日期	截止日期
0){ $date='Y' ;}?> class="checkbox"/>			" alt="編輯圖檔元素" title="編輯圖檔元素" width="75" />