01.<?
02.require_once "connectdb.php";
03.$chk_d = date('Y-m-d');
04.?>
07.<head>
08.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
09.<link href="style.css" rel="stylesheet" type="text/css">
10.<title>Untitled Document</title>
11.</head>
12.
13.<body>
14.
15.<div align="center">วันที่ : <? echo "$chk_d"; ?><br />
16. <?
17.$num=1;
18.$sqlgroup = "select * from grouptb order by id asc";
19.$resultcg = mysql_query($sqlgroup) or die(mysql_error());
20.while($rowg = mysql_fetch_array($resultcg))
21.{
22.$idgroup = $rowg['id'];
23.$groupname = $rowg['groupname'];
24.?>
25.</div>
26.<table width="28%" border="0" align="center" cellpadding="6" cellspacing="0">
27. <tr>
28. <td height="33" bgcolor="#990000"><font color="#FFFF00"><? echo "$groupname"; ?></font></td>
29. </tr>
30. <tr>
31. <td bgcolor="#99CCFF"><?
32.$today_chk = date('Y-m-d');
33.$num=1;
34.$sqlprg = "select * from studenttb where dateregist = '$today_chk' and groupid = '$idgroup'";
35.$resultpg = mysql_query($sqlprg) or die(mysql_error());
36.while($rowpg = mysql_fetch_array($resultpg))
37.{
38.$idstu = $rowpg['id'];
39.$name = $rowpg['name'];
40.$position = $rowpg['position'];
41.?>
42. <table width="100%" border="0" cellspacing="0" cellpadding="0">
43. <tr>
44. <td height="35" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="1" cellpadding="8">
45. <tr>
46. <td width="53%" height="23"><div align="left"><font class="txtkanda_r_18"><? echo "$name"; ?></font></div></td>
47. <td width="47%"><div align="center"><font class="txtkanda_r_18"><? echo "$position"; ?></font></div></td>
48. </tr>
49. </table></td>
50. </tr>
51. </table>
52. <?
53. $num=$num+1;
54. }
55. ?></td>
56. </tr>
57.</table>
58.<?
59. $num=$num+1;
60. }
61. ?>
62.
63.</body>
64.</html>
