$sql= "select djs_skupdate_class.id,djs_skupdate_class.grouptypeid,djs_skupdate_class.teachername,djs_skupdate_class.years,djs_skupdate_class.saydate,djs_skupdate_class.isupdate,djs_skgrouptype.groupname from djs_skupdate_class,djs_skgrouptype where djs_skupdate_class.grouptypeid = djs_skgrouptype.id ";
$sql="select * from djs_skupdate_class";
//print_r($sql);
$dsql->Execute('me',$sql);
while($arr = $dsql->GetArray('me')){
$row[]=array(
'id' => $arr['id'],
//'grouptypeid' => $arr['grouptypeid'],
'groupname' => $arr['groupname'],
'teachername' => $arr['teachername'],
'years' => $arr['years'],
'saydate' => $arr['saydate'],
'isupdate' => $arr['isupdate']
);
}
$sql="select * from djs_skupdate_class";
//print_r($sql);
$dsql->Execute('me',$sql);
while($arr = $dsql->GetArray('me')){
$row[]=array(
'id' => $arr['id'],
//'grouptypeid' => $arr['grouptypeid'],
'groupname' => $arr['groupname'],
'teachername' => $arr['teachername'],
'years' => $arr['years'],
'saydate' => $arr['saydate'],
'isupdate' => $arr['isupdate']
);
}
foreach($row as $k=>$v){
?>
<tr align="center" bgcolor="#FFFFFF" height="26" onMouseMove="javascript:this.bgColor='#FCFDEE';"
onMouseOut="javascript:this.bgColor='#FFFFFF';">
<td><?php echo $v['id']; ?></td>
<td><?php echo $v['grouptypeid'] ?></td>
<td><?php echo $v['teachername']?></td>
<td><?php echo $v['years'].$v['saydate']?></td>
<td><?php if($v['isupdate']==1){echo"已更新";}else{echo "未更新";} ?></td>
<td>
<a href='#'>[更改]</a>
<a href='#'>[删除]</a>
</td>
</tr>
<?php
}
?>
$sql="select * from djs_skupdate_class";哪来的多表?
这条吗?
但他不是被下面的
$sql="select * from djs_skupdate_class";
覆盖了吗?
$you='李四';
你是李四了,不是张三。