01.<?php
02.
03.include("conn.php") ;
04.$sql = "SELECT subject.s_id , student.student_id , student.s_id , student.date , student.point FROM subject LEFT JOIN student USING(s_id) WHERE student.student_id = student2";
05.$sqlquery = mysql_db_query($dbname, $sql);
06.?>
07.<table width="90%" border=0 cellpadding=4 align=center>
08.<tr>
09.<td> </td>
10.<td> </td>
11.</tr>
12.</table>
13.<table width="50%" cellspacing="1" cellpadding="0" align="center">
14.<tr>
15. <td height="35" bgcolor="#FFE4E1"><DIV align="center"><span class=style5>#</span></div></td>
16. <td height="35" bgcolor="#FFE4E1"><DIV align="center"><span class=style5>s_id</span></div></td>
17. <td height="35" bgcolor="#FFE4E1"><DIV align="center"><span class=style5>student_id</span></div></td>
18. <td height="35" bgcolor="#FFE4E1"><DIV align="center"><span class=style5>Date</span></div></td>
19. <td height="35" bgcolor="#FFE4E1"><DIV align="center"><span class=style5>point</span></div></td>
20. </tr>
21.
22. <?
23. $item = 1;
24. while($row=mysql_fetch_row($sqlquery))
25. {
26. $i++;
27. if($i%2==0)
28. {
29. $bg = "#DDDDDD";
30. }
31. else
32. {
33. $bg = "#F7F7F7";
34. }
35. ?>
36. <tr bgcolor="<?=$bg;?>">
37. <td><div align=center><span class=style8><?=$item?>.</div></span></td>
38. <td><div align=center><span class=style8><?=$row[0]?></div></span></td>
39. <td><div align=center><span class=style8><?=$row[1]?></div></span></td>
40. <td><div align=center><span class=style8><?=$row[3]?></div></span></td>
41. <td><div align=center><span class=style8><?=$row[4]?></div></span></td>
42. </tr>
43.
44. <?
45. $item++;
46. }
47. ?>
48.</table>
