[Resolved] first record clipped!

[esbsolutions]

Anybody have an idea why this does not return the first record? It displays all other records for some reason, but does not display the very first one even though the record is definitely stored in the database. Thanks!

<?php

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

if($insertresult)
	{
	$theQuery = "SELECT * FROM listings WHERE id='$AgencyID'";
	$agencyquery= mysql_query($theQuery);

if (!$agencyquery)
	{
	echo 'Cannot select database.  <br /><br />
	Click <a href="admin.php" class="roll">here</a> if you are not redirected.';

	if(strtolower(substr($transfer, 0, 4))!='http')
    		{
		$base = ($_SERVER['HTTPS'] == 'on' ? "https://" : "http://");
		$base .= $_SERVER['HTTP_HOST'];
		if(dirname($_SERVER['PHP_SELF']) != '/')
		$base .= dirname($_SERVER['PHP_SELF']);
		$transfer = $base.'/'.$transfer;
		}
	header("Location: $transfer");
	exit;
	}

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

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

	mysql_select_db('esbsolu_powerbucks');
	$JobNumHoursSum = "SELECT AgencyID, JobNum, Project, SUM(Hours) from transactions GROUP BY JobNum HAVING AgencyID='".$r['id']."' ORDER BY JobNum ASC";
        	$JobNumHoursSumResult=mysql_query($JobNumHoursSum);
	$transactions= mysql_result($JobNumHoursSumResult,0);

        	$num_results = mysql_num_rows($JobNumHoursSumResult) or die(mysql_error());

    	if ($num_results == 0)
            	{
		echo '<h3>Agency Report: '.$agency .'</h3><p><center><br /><h5>BALANCE: $'.$budget.'</h5><br /><a href="form.php" class="roll">Go back</a>';
		exit;
            	}

            echo '<h3>Agency Report: '.$agency .'</h3><p><center><br /><h5>TRANSACTIONS:</h5><table border="0" width="500"><tr><td align="left"><b>Job Number</b></td><td align="left"><b>Project</b></td><td align="right"><b>Hours</b></td></tr>';

        	while($r = mysql_fetch_array($JobNumHoursSumResult))
            	{
                	$JobNum=$r["JobNum"];
                	$Project=$r["Project"];
                	$Hours=$r["SUM(Hours)"];

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

        	echo '</table><h5>BUDGET:$'.$budget.'      
        	BALANCE: $'.$Balance.'</h5><br />
	<a href="form.php" class="roll">Go back</a>';

	}
    }
?>

[tomhath]

I'd suspect there's something wrong with the id value in that record, maybe a leading blank or other whitespace.

Maybe try and ORDER BY to force it into selecting some other rows first to see if it always skips the first row or the missing row.