01.<table border="0" cellspacing="0" cellpadding="0" align="center">
02.<tr>
03.<?
04. $sql = "select * from student where student_altitude ='$student_altitude' and student_room='$student_room' and student_sex='M' ORDER BY `student`.`id_student` ASC " ;
05.$dbquery = mysql_db_query($dbname, $sql);
06.$cols = 4;
07.$c = $cols;
08.while($result = mysql_fetch_array($dbquery)) {
09.$c --;
10.$idstd1 = $result[idstd];
11.$id_student31 = $result[id_student];
12.$student_name31 = $result[student_name];
13.$student_familyname31 = $result[student_familyname];
14.
15.?>
16.<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>
17.<?
18.if($c == 0) {
19.$c = $cols;
20.?>
21.</tr></tr>
22.<? } } ?>
23.
24.<?
25. $sql = "select * from student where student_altitude ='$student_altitude' and student_room='$student_room' and student_sex='F' ORDER BY `student`.`id_student` ASC " ;
26.$dbquery = mysql_db_query($dbname, $sql);
27.
28.
29.while($result = mysql_fetch_array($dbquery)) {
30.$c --;
31.$idstd1 = $result[idstd];
32.$id_student31 = $result[id_student];
33.$student_name31 = $result[student_name];
34.$student_familyname31 = $result[student_familyname];
35.
36.?>
37.<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>
38.<?
39.if($c == 0) {
40.$c = $cols;
41.?>
42.</tr></tr>
43.<? } } ?>
44.</tr></table>
45.
46.
47.
48. </td>
49.
50. </table>
51.
52.
53. <br> </td>
54.
55. </table>
56.
57.
58. <p> </p>
59. <p align="right">
60. <? echo"$user " ; ?>
61. <br>
62. </p>
63. <p> </p>
64. <p>
65. <? mysql_close(); ?>
66. </p></td>
67. </tr>
68. </table></td>
69. </tr>
70. </table></td>
71. </tr>
72.</table>
73.</body>
74.</html>
