session_start(); if ($_SESSION['gh']==''){ header('location:login.php'); } include("config.php"); $sql="select * from module"; $result=mssql_query($sql,$conn); $num=mssql_num_rows($result); //echo $num; ?>
$sql='select * from module where id not in (select mokuaiid from geren where gh ='.$_SESSION['gh'].')'; $result=mssql_query($sql,$conn); while($myrow=mssql_fetch_array($result)) echo ''.$myrow['mn'].''; ?>
for ($p=1; $p<=$num;$p=$p+2){ echo '
'; $sql='geren where biaogeid='.$p.からmokuaiidを選択します。' そして gh ='.$_SESSION['gh']; $result=mssql_query($sql,$conn); while($myrow=mssql_fetch_array($result)){ $sql='select * from module where id='.$myrow['mokuaiid']; $result1=mssql_query($sql,$conn); while($myrow1=mssql_fetch_array($result1)){ echo ''.$myrow1['mn'].''; } } echo '
'; } ?>
for ($p=2; $p<=$num;$p=$p+2){ echo '
'; $sql='geren where biaogeid='.$p.からmokuaiidを選択します。' そして gh ='.$_SESSION['gh']; $result=mssql_query($sql,$conn); while($myrow=mssql_fetch_array($result)){ $sql='select * from module where id='.$myrow['mokuaiid']; $result1=mssql_query($sql,$conn); while($myrow1=mssql_fetch_array($result1)){ echo ''.$myrow1['mn'].''; } } echo '