mysql_connect($host,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");



$query = "SELECT DISTINCT info647_crse . crsdesc , info647_crse . crsprice FROM info647_emp JOIN info647_reg USING ( empno ) JOIN info647_off USING ( offerno ) JOIN info647_crse USING ( crsno ) WHERE empno = '$empno' LIMIT 0, 30 ";
$result=mysql_query($query);

$num=mysql_numrows($result);




mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;



while ($i < $num) {





$desc=mysql_result($result,$i,"crsdesc");

$crsprice=mysql_result($result,$i,"crsprice");






echo "<br>Class: $desc<br>Price: $crsprice<br><br><hr><br>";

$i++;

}

echo("Total Price of Classes for employee $empno :");
echo("<p align='center'><font face='Arial' size='3' color='#FF0000'>Employee Queried</font></p>");
include("footer.html");

?>

while ($i < $num) {





$desc=mysql_result($result,$i,"crsdesc");

$crsprice=mysql_result($result,$i,"crsprice");






echo "<br>Class: $desc<br>Price: $crsprice<br><br><hr><br>";

$i++;

}
$crsprice1=$crsprice1+$crsprice
echo("Total Price of Classes for employee# $empno ");
echo ("$crsprice1");
echo("<p align='center'><font face='Arial' size='3' color='#FF0000'>Employee Queried</font></p>");

include("footer.html");

?>