help with sum()

[esbsolutions]

For some reason it is posting the resource id instead of the appropriate output at line 230 ($HoursSum variable). Can anyone tell me what's up, so I can add all the values from the Hours column?

<?php
session_start();


if(isset($HTTP_POST_VARS['username']) && isset($HTTP_POST_VARS['password']))
	{
	// if user just tried to log in
	$username = $HTTP_POST_VARS['username'];
	$password = $HTTP_POST_VARS['password'];
        $timestamp = date("y-m-d-H-i");

//connect to mysql
$db = @mysql_connect('localhost', 'user', 'pass');

if(!$db)
	{
	echo 'Cannot connect to database.';
	exit;
	}

//select the appropriate database
$mysql = mysql_select_db('esbsolu_powerbucks');
if(!$mysql)
	{
	echo 'Cannot select database.';
	exit;
	}

//query the database to see if there is a record which matches
$query = "select count(*) from authentication where
username='$username' and password='$password'";

$result = mysql_query( $query ) or die(mysql_error());
if(!$result)
	{
	echo 'Cannot run query.';
	exit;
	}

$count = mysql_result ( $result, 0, 0 );

if ($count > 0)
	{

	// username is verified, now register the username

	$HTTP_SESSION_VARS['valid_user'] = $username;		

	}

}
?>

<?include("header.php");?>

<?php
if (isset($HTTP_SESSION_VARS['valid_user']))
	{
	if ($HTTP_SESSION_VARS['valid_user'] == Administrator)
		{
		?>

	<center>
            <?include("adminnav.php");?>
	<form method="post" action="<?php echo $PHP_SELF; ?>">
	<?php

	if (!$submit)

		{
                    ?>

                    <table width="500" border="0" valign="top" align="center">
                    <tr><td width="500" border="0" valign="top" align="center">
                    Welcome, Administrator.  Please select one of the following agencies in order to view their PowerBucks Reports, or click one of the above links.<br /><br />

                    <?php
		$db = @mysql_connect('localhost', 'esbsolu_esbsolu', 'armagita');

		if(!$db)
			{
			echo 'Cannot connect to database.';
			exit;
		}
		$mysql = mysql_select_db('esbsolu_powerbucks');
		if(!$mysql)
			{
			echo 'Cannot select database.';
			exit;
			}
		// populate the drop down menu 
		$namepull = "SELECT * FROM listings ORDER BY id ASC"; 
		// execute SQL query and get result 
		$nameput = mysql_query($namepull) or die(mysql_error()); 

		// put data into drop-down list box 
		while ($r = mysql_fetch_array($nameput)) 
			{ 
			$agency=$r["agency"]; 
			$agencies .= "<option value=\"$agency\">$agency"; 
			} 

		?> 
		<select name="selectedagency" id="agency" size="1" style="background-color:#F7F7F7;">
		<? echo "<option value=\"0\" selected>Select Agency Report";?> 
		<? echo "$agencies"; ?> 
		</select>
		<input type="submit" name="submit" value="Submit" class="button">
		</form>
                    </td></tr></table>
		</center>
		<?php

		}

	if($submit)	
		{
		$selectedagency = $_POST['selectedagency'];
		$db = @mysql_connect('localhost', 'esbsolu_esbsolu', 'armagita');

		if(!$db)
			{
			echo 'Cannot connect to database.';
			exit;
			}	
		$mysql = mysql_select_db('esbsolu_powerbucks');
		if(!$mysql)
			{
			echo 'Cannot select database.';
			exit;
			}

		$theQuery = "SELECT * FROM listings WHERE agency='".$selectedagency."'"; 
		$agencyquery= mysql_query($theQuery) OR die(mysql_error());	            


		echo '<hr width="70%"><p><center><h3>Agency Report: '.$HTTP_SESSION_VARS['valid_user'].'</h3><br />';


		mysql_select_db('esbsolu_powerbucks');

		$report= mysql_query("select * from listings where agency='".$HTTP_SESSION_VARS['valid_user']."' ORDER BY id ASC");

		$num_results = mysql_num_rows($report);


		if ($num_results == 0)
			{
			echo 'There are no records in your database.';
			exit;
			}


		while($r = mysql_fetch_array($report)) 
			{     
		        $id=$r["id"]; 
			$agency=$r["agency"];
		        $budget=$r["budget"]; 

		        echo 'Your PowerBucks budget is $'.$budget.'.<br /><br />Your PowerBucks transactions are:<br /><br /><table border="0" width="500"><tr><td align="left"><b>Employee</b></td><td align="left"><b>Client</b></td><td align="left"><b>Job Number</b></td><td align="left"><b>Project</b></td><td align="left"><b>Hours</b></td><td align="left"><b>Balance</b></td></tr>';


			mysql_select_db('esbsolu_powerbucks');

			$transactions= mysql_query("select * from transactions where AgencyID='".$r['id']."' ORDER BY JobNum ASC");

			$num_results = mysql_num_rows($report);


			if ($num_results == 0)
				{
				echo 'There are no records in your database.';
				exit;
				}


			while($r = mysql_fetch_array($transactions)) 
				{     
		        	$Employee=$r["Employee"]; 
		                $Client=$r["Client"];
		        	$JobNum=$r["JobNum"]; 
		        	$Project=$r["Project"];				
		        	$Hours=$r["Hours"];
		        	$AgencyID=$r["AgencyID"];


				echo '<tr><td align="left">'.$Employee.'</td><td align="left">'.$Client.'</td><td align="left">'.$JobNum.'</td><td align="left">'.$Project.'</td><td align="left">'.$Hours.'</td></tr>';
				}

			echo '</table><br /><br />';

			}	

		}

	}
else
	{

	mysql_select_db('esbsolu_powerbucks');
		$query = "INSERT INTO tracking VALUES('$username','$timestamp')";

		mysql_query($query) or die(mysql_error());


	echo '<hr width="70%"><p><center><h3>Agency Report: '.$HTTP_SESSION_VARS['valid_user'].'</h3><br />';


	mysql_select_db('esbsolu_powerbucks');

	$report= mysql_query("select * from listings where agency='".$HTTP_SESSION_VARS['valid_user']."' ORDER BY id ASC");

	$num_results = mysql_num_rows($report);


	if ($num_results == 0)
		{
		echo 'There are no records in your database.';
		exit;
		}


	while($r = mysql_fetch_array($report)) 
		{     
    		$id=$r["id"]; 
                $agency=$r["agency"];
    		$budget=$r["budget"]; 

		mysql_select_db('esbsolu_powerbucks');			
		$HoursSum= "SELECT sum(Hours) FROM transactions WHERE AgencyID=$id";
		echo $HoursSum;
		$TotalHours= mysql_query($HoursSum);
		echo $TotalHours;
		$Balance= $budget - (100*$TotalHours);

    		echo '<h5>TRANSACTIONS:</h5><table border="0" width="500"><tr><td align="left"><b>Employee</b></td><td align="left"><b>Client</b></td><td align="left"><b>Job Number</b></td><td align="left"><b>Project</b></td><td align="left"><b>Hours</b></td></tr>';


		mysql_select_db('esbsolu_powerbucks');

		$transactions= mysql_query("select * from transactions where AgencyID='".$r['id']."' ORDER BY JobNum ASC");

		$num_results = mysql_num_rows($transactions);


		if ($num_results == 0)
			{
			echo 'There are no records in your database.';
			exit;
			}


		while($r = mysql_fetch_array($transactions)) 
			{     
    			$Employee=$r["Employee"]; 
            		$Client=$r["Client"];
    			$JobNum=$r["JobNum"]; 
    			$Project=$r["Project"];				
    			$Hours=$r["Hours"];
    			$AgencyID=$r["AgencyID"];

			echo '<tr><td align="left">'.$Employee.'</td><td align="left">'.$Client.'</td><td align="left">'.$JobNum.'</td><td align="left">'.$Project.'</td><td align="left">'.$Hours.'</td></tr>';
			}

		echo '</table><h5>BUDGET:$'.$budget.' &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
		BALANCE: $'.$Balance.'</h5><br /><br />';

		}	


	echo '<a href="logout.php" class="roll">Log Out</a></center></p>';

	}

}

else
	{
	if (isset($username))
		{
		// if user tried and failed to log in
		echo '<hr width="70%"><br /><h1 align="center" style="letter-spacing:0em;">Authentication failed.</h1>';
		}
	else
		{
		// if user has not tried to log in yet or has logged out
		echo '<hr width="70%"><br />Please log in:';
		}

	//provide form to log in
	echo '<p><center>
	<form method="post" action="index.php">
	<table border="0">
	<tr>
	<th>Username:</th>
	<td><input type="text" name="username"></td>
	</tr>
	<tr>
	<th>Password:</th>
	<td><input type="password" name="password"></td>
	</tr>
	<tr>
	<td colspan="2" align="center">
	<br />
	<input type="submit" value="Authenticate" class="button">
	</td></tr></table></form></center></p>';

}


?>

<?include("footer.php");?>

[Weedpacket]

(a) Please read the general guidelines in the Newbie's forum before posting such a large amount of code again.

(b) Your problem is that you're trying to print the resource (which is why it gives a resource #), instead of fetching the sum out of the resource the way you as for everything else.

The problem (and the bit that needed posting) is here:

$HoursSum= "SELECT sum(Hours) FROM transactions WHERE AgencyID=$id";
            echo $HoursSum;
            $TotalHours= mysql_query($HoursSum);
            echo $TotalHours; 

should be

$HoursSum= "SELECT sum(Hours) FROM transactions WHERE AgencyID=$id";
            echo $HoursSum;
            $result=mysql_query($HoursSum);
            $TotalHours= mysql_result($result,0);
            echo $TotalHours; 

Oh, and you really don't need to keep selecting the same database over and over again with ever query.