show checkbox data mysql

[DirtyTodd]

I am having some minor errors and was wondering if anyone could help!I am creating a attendance system for a college. This Scenario: Student logs in successfully and then wants to view his/her attendance for a particular course.Problem: I want it to show me both checked and uncheked data from mysql, it currently shows an empty checkbox (when its meant to be checked) also at the moment it is showing numerous duplicated data, is it possible i could limit that, say for example show one record per week , it shows all data and duplicates it. \[code\]<?php$q3= "SELECT attendance.week_number_id, attendance.week_number, courses.course_id, students.student_id, course_attendance.present, course_attendance.notes FROM courses, course_attendance, attendance, studentsWHERE course_attendance.student_id= ".$_SESSION['student_id']." AND course_attendance.course_id= courses.course_id AND course_attendance.week_id= attendance.week_number_id AND courses.course_id='101' ";$result = mysql_query($q3) or die(mysql_error());echo "<table border='1' align='center'><tr> <th><strong>Week Number</strong></th> <th><strong>Present</strong></th> <th><strong>Notes</strong></th> </tr> ";while($row = mysql_fetch_assoc($result)){ extract($row);echo "</td><td width='200' align='center'>" .$row['week_number']."</td><td width='400' align='center'><input type='checkbox' name='present'" .$row['present']. "</td><td width='400' align='center'>" .$row['notes']."</td><tr>";}echo "</table>";?>\[/code\]Note: I am connected successfully to database, mysql is up and running, i am using sessions, currently it does show data for the student but does not show the existing checked or uncheked value, the checkbox is empty.Can anyone help