<?php require('system/login.php');  ?>
<?php require_once('../Connections/BE2.php'); ?>
<?php

if(isset($_GET['del_id']) && ( $_GET['del_id']>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());
}


mysql_select_db($database_BE2, $BE2);
$query_Rt2 = "SELECT * FROM udat where ud4='Y' order by ud5 ASC";
 

//$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); 
?>
  

  <table width="731" border="0" cellpadding="0" cellspacing="0">
    <tr>
      <th width="3%" nowrap="nowrap" class="font2">ID</th>
      <th width="26%" nowrap="nowrap" class="font2">合作廠商說明</th>
      <th width="25%" nowrap="nowrap" class="font2">&nbsp;</th>
      <th nowrap="nowrap" class="font2">編輯列表</th>
      <th nowrap="nowrap" class="font2">&nbsp;</th>
      <th nowrap="nowrap" class="font2">排列序</th>
      <th nowrap="nowrap" class="font2">刪除</th>
    </tr>
    <?php 
	 if($totalRows_Rt2>0){ 
	  do { ?>
    <tr>
      <td align="center" class="font3"><a href="main.php?act=edit_udat&id=<?php echo $row_Rt2['ud0']; ?>"><img src="images/edit.png" alt="修改項目名稱" title="修改項目名稱" width="16" height="16" border="0" /></a></td>
      <td align="center" class="font3"><?php echo $row_Rt2['ud1']; ?></td>
      <td align="center" class="font3">&nbsp;</td>
      <td width="20%" align="center" class="font3"><a href="main.php?act=causer&kid=<?= $row_Rt2['ud0']; ?>"><img src="images/browse.png" alt="編輯圖檔元素" title="編輯圖檔元素" width="32" height="32" /></a>

      </td>
      <td width="5%" align="center" class="font3">
      </td>
      <td width="15%" align="center" class="font3"><?php echo $row_Rt2['ud5']; ?></td>
      <td width="6%" align="center" class="font3"><a href="javascript:if(confirm('確實要刪除嗎?'))location='<? echo 'main.php?act=udat&del_id='.$row_Rt2['ud0'] ;?>'"><img src="images/del.png" alt="刪除項目" width="16" height="16" border="0"/></a></td>
    </tr>
    <?php } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); 
	 }
	  ?>

  </table>

<?php
mysql_free_result($Rt2);
?>
