Display problems

gitosh

Hello people, I'm developing a php program that retrives and displays information form a SQL 2000 database given a parameter. I'm using the microsoft SQL server functions. before displaying the data, I have the following code that tells me the number of records that were found.

echo "<h2>" . $numrows . " Record" . ($numrows == 1 ? "" : "s") . " Found: </h2>";

if 4 records were found,the above code displays something like "4 Records found"
The problem is the number of records displayed is one less the number of records found. Like in the above example where four records are found, only 3 records are displayed. That means if only one record was found, it's not displayed. what could be the problem?

NB: Since I'm using stored procedures, I've tested them on the database and verified that if it's four records, it's really four records that exist in the database.

Thanks in advance.

bradgrafelman

Sounds like you're calling a function that retrieves a row from the result, and then following that with a loop. In other words, you waste the first row, and then loop through what's left (n - 1).

Show us the surrounding code (that retrieves and outputs data) if you can't figure out what I'm talking about.

gitosh

ok, here is part of the code

elseif($_POST['vselect']=="Invoice No")
{

	   $x=intval($_POST['svalue']);
	   $sqlquery3=mssql_init("Gssp_GetCustomerDetailsGivenInvNo",$sqlconnect);
	   mssql_bind($sqlquery3,"@InvNo",&$x,SQLVARCHAR);
	   $result3=mssql_execute($sqlquery3);
	   $numrows=mssql_num_rows($result3);

	   echo "<h2>" . $numrows . " Record" . ($numrows == 1 ? "" : "s") . " Found: </h2>";

	   while($row=mssql_fetch_array($result3))
		  {
		 if ($row['OrgName'])
		   {

	        echo '<Table border=1 align=center>';
	        echo '<tr bgcolor=#999999>';	
	        echo '<td><b>&nbsp;Organization Name&nbsp;</b></td>';
	        echo '<td><b>&nbsp;Plot No&nbsp;</b></td>';
	        echo '<td><b>&nbsp;Cell&nbsp;</b></td>';
	        echo '<td><b>&nbsp;Sector&nbsp;</b></td>';
	        echo '<td><b>&nbsp;District&nbsp;</b></td>';
	        echo '<td><b>&nbsp;Invoice No&nbsp;</b></td>';
	       echo '<td><b>&nbsp;Invoice Date&nbsp;</b></td>';
	        echo '<td><b>&nbsp;Invoice Amount&nbsp;(Rfr)</b></td>';
			echo '<td><b>&nbsp;Amount Paid&nbsp;(Rfr)</b></td>';
	        echo '<td><b>&nbsp;Balance&nbsp;(Rfr)</b></td>';
	        echo '</tr>';



		  	$orgname=trim($row['OrgName']);
	        $Plotno=trim ($row['PlotNo']);
		    $cell=trim($row['cellname']);
	        $sector=trim($row['SectName']);
	        $district=trim($row['DistName']);
			$invoiceno=trim($row['InvNo']);
			$InvDate=trim($row['RegDate']);
			$Invamount=number_format($row['Grandtotal'],2);
			$AmountPaid=number_format($row['AmountPaid'],2);
	        $Balance=number_format($row['Balance'],2);


		   echo '<tr>';
	       echo "<td valign='top'> $orgname &nbsp;</td>";
	       echo "<td valign='top'> $Plotno &nbsp;</td>";
		   echo "<td valign='top'> $cell &nbsp;</td>";
		   echo "<td valign='top'> $sector &nbsp;</td>";
		   echo "<td valign='top'> $district &nbsp;</td>";
		   echo "<td valign='top'> $invoiceno &nbsp;</td>";
		   echo "<td valign='top'> $InvDate &nbsp;</td>";
		   echo "<td valign='top'> $Invamount &nbsp;</td>";
		   echo "<td valign='top'> $AmountPaid &nbsp;</td>";
		   echo "<td valign='top'> $Balance &nbsp;</td>";
		   echo '</tr>';
			}
			   elseif(!$row['OrgName'])
			    {


                echo '<Table border=1 align=center>';
	            echo '<tr bgcolor=#999999>';
	            echo '<td><b>&nbsp;First Name&nbsp;</b></td>';
	            echo '<td><b>&nbsp;Middle Name&nbsp;</b></td>';
	            echo '<td><b>&nbsp;Last Name&nbsp;</b></td>';
	            echo '<td><b>&nbsp;Plot No&nbsp;</b></td>';
	            echo '<td><b>&nbsp;Cell&nbsp;</b></td>';
	            echo '<td><b>&nbsp;Sector&nbsp;</b></td>';
	            echo '<td><b>&nbsp;District&nbsp;</b></td>';
	            echo '<td><b>&nbsp;Invoice No&nbsp;</b></td>';
	            echo '<td><b>&nbsp;Invoice Date&nbsp;</b></td>';
	            echo '<td><b>&nbsp;Invoice Amount&nbsp;(Rfr)</b></td>';
			    echo '<td><b>&nbsp;Amount Paid&nbsp;(Rfr)</b></td>';
	            echo '<td><b>&nbsp;Balance&nbsp;(Rfr)</b></td>';
	            echo '</tr>';
				 while($row=mssql_fetch_array($result3))
				 {

				$fname=trim($row['Fname']);
	            $mname=trim($row['Mname']);
	            $lname=trim($row['Lname']);
         		$plotno=trim($row['PlotNo']);
                $cell=trim($row['Cellname']);
	            $sector=trim($row['SectName']);
	            $district=trim($row['DistName']);
	            $invoiceno=trim($row['InvNo']);
	            $InvDate=trim($row['RegDate']);
			    $Invamount=number_format($row['Grandtotal'],2);
			    $AmountPaid=number_format($row['AmountPaid'],2);
	            $Balance=number_format($row['Balance'],2);


			   echo '<tr>';
	           echo "<td valign='top'> $fname &nbsp;</td>";
	           echo "<td valign='top'> $mname &nbsp;</td>";
         	   echo "<td valign='top'> $lname &nbsp;</td>";
	           echo "<td valign='top'> $plotno &nbsp;</td>";
	           echo "<td valign='top'> $cell &nbsp;</td>";
	           echo "<td valign='top'> $sector &nbsp;</td>";
	           echo "<td valign='top'> $district &nbsp;</td>";
	           echo "<td valign='top'> $invoiceno &nbsp;</td>";
	           echo "<td valign='top'> $InvDate &nbsp;</td>";
		       echo "<td valign='top'> $Invamount &nbsp;</td>";
		       echo "<td valign='top'> $AmountPaid &nbsp;</td>";
		       echo "<td valign='top'> $Balance &nbsp;</td>";
	           echo '</tr>';		
        }
             echo '</table>';
			     }
		  }
			echo '</table>';



	 }
}