Student information Student name:'; echo $name; echo 'Student ID'; /*The file contains authentication information*/ require "/home/www/data/labReservation.conf"; $work_link=mysql_connect($host,$user,$passwd); mysql_select_db("labReservation",$work_link) or die ("Couldn't select!"); $query="select number from reservedWorks where name='$name'"; $result=mysql_query($query) or die ("Couldn't query"); $row1=mysql_fetch_array($result); $query="select studentID,work,grade,date from register where name='$name'"; $result=mysql_query($query) or die ("Couldn't query"); echo "$row1[0]"; echo 'Approved worksGrade'; while($row=mysql_fetch_array($result)){ echo "$row[1]$row[3]"; if($row[2]==6) echo "Approved"; else echo $row[2]; echo ""; } echo ""; } else{ echo 'This service demands valid authentication.'; } ?>