查看文件: settb3.php

大小: 3.05 KB

类型: application/octet-stream

<?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_Rtc = "SELECT distinct(fe2) FROM tb5 where 1 order by fe1,fe2,fe4";
$Rtc = mysql_query($query_Rtc, $BE2) or die(mysql_error());
$row_Rtc = mysql_fetch_assoc($Rtc);
$totalRows_Rtc  = mysql_num_rows($Rtc);
$colname_Rt2 = $row_Rtc["fe2"];

if (isset($_GET['feid'])) {
  $colname_Rt2 = $_GET['feid'];
}

mysql_select_db($database_BE2, $BE2);
 
$query_Rt2 = sprintf("SELECT * FROM tb5 where fe2='%s' order by fe1,fe2,fe4",$colname_Rt2);

$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2  = mysql_num_rows($Rt2); 
?>
  <form name="form" id="form">
    <select name="jumpMenu" id="jumpMenu" onchange="MM_jumpMenu('self',this,0)">
     <? do { ?>
      <option value="main.php?act=settb3&feid=<?= $row_Rtc['fe2'] ; ?>" <? if($row_Rtc['fe2']==$colname_Rt2){ ?> selected="selected" <? }?>><?php echo $row_Rtc['fe2'] ; ?></option>
      <?php } while ($row_Rtc = mysql_fetch_assoc($Rtc)); ?> 
    </select>
  </form>
<table width="862" border="0" cellpadding="0" cellspacing="0">
  <tr>
      <th width="3%" height="23" nowrap="nowrap" class="font2">ID</th>
      <th width="8%" nowrap="nowrap" class="font2">項目</th>
      <th width="19%" nowrap="nowrap" class="font2">服務分類</th>
      <th width="15%" align="left" nowrap="nowrap" class="font2">服務說明</th>
      <th nowrap="nowrap" class="font2">內文說明</th>
      <th nowrap="nowrap" class="font2">排列序</th>
      <th nowrap="nowrap" class="font2">&nbsp;</th>
      <th nowrap="nowrap" class="font2">&nbsp;</th>
    </tr>
    <?php 
	 $ar1=array("租車查詢","觀光旅遊","企業徵才");

if($totalRows_Rt2>0){ 
	  do { ?>
    <tr>
      <td align="center" class="font3"><a href="main.php?act=edittb3&amp;id=<?php echo $row_Rt2['fe0']; ?>"><img src="images/edit.png" alt="修改項目名稱" title="修改項目名稱" width="16" height="16" border="0" /></a></td>
      <td align="center" class="font3"><?php echo $ar1[$row_Rt2['fe1']-6]; ?></td>
      <td align="center" nowrap="nowrap" class="font3"><?php echo $row_Rt2['fe2']; ?></td>
      <td align="left" nowrap="nowrap" class="font3"><?php echo $row_Rt2['fe3'] ; ?></td>
      <td width="42%" align="center" class="font3"><?php echo mb_substr($row_Rt2['fe5'],0,20,"utf-8"); ?></td>
      <td width="10%" align="center" class="font3"><h3><font color="#FF0000"><?php echo $row_Rt2['fe4'];?></font></h3></td>
      <td width="2%" align="center" class="font3">&nbsp;</td>
      <td width="1%" align="center" class="font3">&nbsp;</td>
    </tr>
    <?php } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); 
	 }
	  ?>

</table>

<?php
mysql_free_result($Rtc);
mysql_free_result($Rt2);
?>