"; include("header.php"); require_once('db_config.php'); $sql="select * from $_std where std_id>1 order by std_power desc"; $result=mysql_query($sql); echo "
รายชื่อสมาชิกที่เข้าเรียนทั้งหมด เรียงตามพลังความรู้ "; $rw=1; $col=1; while ($db=mysql_fetch_array($result)) { $sql2="select * from $_like where lke_std2='$db[std_id]' group by lke_std1,lke_std2"; $result2=mysql_query($sql2); $nlike=mysql_num_rows($result2); if ($nlike==0) { $nlike=''; } else { $nlike=" $nlike"; } if (empty($db[std_pic])) { $pic="images/std_login.jpg"; } else { $pic="pics/$db[std_pic]"; } if ($col==1) { echo ""; } echo ""; $rw++; $col++; if ($col==11) { echo ""; $col=1; } } echo "

$rw.$db[std_name1] $db[std_room]
$db[std_power] $nlike
"; include("footer.php"); ?>