การนำข้อมูลมาแสดง 4 จำนวนคอลั่ม โดขผู้ชายมาก่อนผู้หญิง และผู้หญิงต่อผู้ชาย

<table  border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<?
 $sql = "select * from student  where student_altitude ='$student_altitude' and student_room='$student_room' and student_sex='M' ORDER BY `student`.`id_student` ASC " ;
$dbquery = mysql_db_query($dbname, $sql);
$cols = 4; //กำหนดจำนวนคอลั่ม 
$c = $cols;
while($result = mysql_fetch_array($dbquery)) {
$c --;
$idstd1 = $result[idstd];
$id_student31 = $result[id_student];
$student_name31 = $result[student_name];
$student_familyname31 = $result[student_familyname];

?>
<td width="200" valign="top"> <? echo "<img src='../../student/pic/$id_student31.JPG' width='189' height='228'><br>$id_student31 $student_name31  $student_familyname31";?> </td>  
<?
if($c == 0) {
$c = $cols;
?>
</tr></tr>
<? } } ?>
  
<?
 $sql = "select * from student  where student_altitude ='$student_altitude' and student_room='$student_room' and student_sex='F' ORDER BY `student`.`id_student` ASC " ;
$dbquery = mysql_db_query($dbname, $sql);
// $cols = 4; //กำหนดจำนวนคอลั่ม 
//$c = $cols;
while($result = mysql_fetch_array($dbquery)) {
$c --;
$idstd1 = $result[idstd];
$id_student31 = $result[id_student];
$student_name31 = $result[student_name];
$student_familyname31 = $result[student_familyname];

?>
<td width="200" valign="top"><? echo "<img src='../../student/pic/$id_student31.JPG' width='189' height='228'><br>$id_student31 $student_name31  $student_familyname31";?> </td>  
<?
if($c == 0) {
$c = $cols;
?>
</tr></tr>
<? } } ?>
</tr></table>



                            </td>
                       
                        </table>
						
						
                        <br> </td>
                  
                  </table>  
					  
					
                  <p>&nbsp;</p>
                  <p align="right"> 
                    <?  echo"$user &nbsp;&nbsp;" ; ?>
                    <br>
                  </p>
                  <p>&nbsp;</p>
                  <p> 
                    <?  mysql_close();   ?>
                  </p></td>
              </tr>
            </table></td>
        </tr>
      </table></td>
  </tr>
</table>
</body>
</html>