suser_class=="Student"){ $fullname = strtoupper($s->sfullname); print<<Welcome

Welcome to your home page $fullname. From here you can navigate your way through the students' area of DentalAssist.org.

Your Classes

Below are all the classes in which you are currently enrolled or classes you have recently completed.

eof; $sql="SELECT classes.* FROM classes LEFT JOIN students USING(class_id) WHERE students.user_id='$s->suser_id' ORDER BY classes.className ASC"; $res= $db->query($sql); if ($res->numRows()==0){ print<< eof; } $printed=0; while($res->fetchInto($row)){ if ($printed%2!=0){$class="list1";}else{$class="list2";} if($row->workbook!=""){ $workbookLink.=<<Download eof; }else{ $workbookLink = "None"; } print<< eof; $printed++; } print<< eof; }else{ // alumni home page $fullname = strtoupper($s->sfullname); $newjobs = $db->getOne("SELECT count(job_id) FROM jobs WHERE post_date>='$s->slastlogin'"); print<<Welcome

Welcome to your home page $fullname. From here you can navigate your way through the alumni area of DentalAssist.org.

Since your last login, there has been $newjobs new jobs posted over in the jobs section. Why not hop over and take a look.

Download your certificates (if available)

Download your transcripts (if available)

eof; } include("inc/foot.php"); ?>
Class Name Class Location View Grades Download Workbook Download Certificates Download Transcripts
You have not been enrolled in any classes
$sql
$row->className $row->schoolLocation View Grades $workbookLink Download Certificates Download Transcripts