日期:2014-05-17 浏览次数:20467 次
<?php
//######################课题列表##########################
include "conn.php";
include "header.php";
?>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<link href="style.css" rel="stylesheet" type="text/css">
<title>课题列表</title>
<style type="text/css">
<!--
.STYLE1 {font-size: 14px}
-->
</style>
<table width="740" border="0" cellspacing="1" cellpadding="0" bgcolor="#333333" align="center">
<tr>
<td width="60" height="30" bgcolor="#CDE6C7"> <div align="center" class="text"> <p class="STYLE1">课题编号</p></div> </td>
<td width="300" height="30" bgcolor="#CDE6C7"> <div align="center" class="title STYLE1">课题名称</div> </td>
<td width="85" height="30" bgcolor="#CDE6C7"> <div align="center" class="STYLE1">指导教师</div></td>
<td width="60" height="30" bgcolor="#CDE6C7"> <div align="center" class="STYLE1">职称</div> </td>
<td width="60" height="30" bgcolor="#CDE6C7"> <div align="center" class="title STYLE1">可选人数</div> </td>
<td width="80" height="30" bgcolor="#CDE6C7" class="title"><div align="center" class="STYLE1">选题情况</div> </td>
<td width="60" height="30" bgcolor="#CDE6C7" class="title"><div align="center" class="STYLE1">状态</div> </td>
<td width="60" height="30" bgcolor="#CDE6C7" class="title"><div align="center" class="STYLE1">详细资料</div> </td>
</tr>
<?php
extract($_REQUEST);
$n=0;
$query=mysql_query("select count(*) as sm from jiaoshi");
mysql_query("set names 'GB2312'");
$row=mysql_fetch_array($query);
$count=$row['sm'];
if(empty($offset))
{$offset=0;}
echo $offset;
$query=mysql_query("select * from jiaoshi order by id asc limit $offset,$list_num") or die ("fail");
mysql_query("set names 'GB2312'");
while($row=mysql_fetch_array($query)){
if(($n%2)!='0'){
echo "<tr bgcolor=#CDE6C7>";}
else{
echo "<tr bgcolor=#FFFFFF>";
}
if($row['surplus']==0)
$ss="不可选";
else $ss="可选";
echo"
<td height='22' class='STYLE1'> <div align='center'>".$row['id']."</div>&l