[JacKDynne]

Resolved

This is how:

Code:

<?
	// get current user sum of straight time
	$query = "SELECT SUM(hours) from log WHERE tid = '1' AND date >= '$sdate' AND date <= '$edate' AND uid = '$_SESSION[SESSION_UID]'";
	$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query . " . mysql_error());
	$reghrs = mysql_result($result, 0);
	
	// correction if sum is zero - explicitly assign it 0, so that it gets printed in report
	if (!$reghrs) { $reghrs = 0; }
?>

and this to print it:

Code:

<tr>
	<td valign=top align=left><font color=#000000>Regular Hours</font>
 &nbsp;
	<td valign=top align=center><font color=#000000><b><? echo sprintf("%1.01f", $reghrs); ?></b></td>
	</tr>

Props out to Sephiroth

/JD