Here is my code I need help with:
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");
?>
It outputs like this:
Class: SEARCHES 102
Price: 300.01
Class: FIREARMS 102
Price: 200.02
Total Price of Classes for employee 1006 :
Employee Queried
Close
What I want to do is add up the Prices and put it after the : part can anyone help me? This is for my info647 class.
Unsolved 
