1 missing record

Anon

So...I am running PHP 4.0.0 on NT 4 Apache 1.3.9 with SQL Server 7.0

I am trying to pull a recordset from the db and drop it into a table, but there is always one record missing from the results set. Here's the important stuff:

$cur=odbc_exec($cnx, "SELECT * FROM MainTB WHERE MerchantNumber = '$MerchSearch'");
if ( !odbc_fetch_row( $cur ) ) {
echo " <center>\nNo records found for $MerchSearch. Please continue.\n";
}
else {

echo "<center>\n \n<table cols=5 border=1>\n<tr>\n<th>Log Number</th>\n<th>Merchant Name</th>\n";
echo "<th>Log Date</th>\n<th>Reason</th>\n<th>Total Amount</th></tr>\n";
while( odbc_fetch_row( $cur ) ) {

	$LogNum=odbc_result($cur, 1);
	$MerchName = odbc_result( $cur, 2 ); 
	$LogDate= odbc_result( $cur, 17);
	$Reason= odbc_result( $cur, 11 );
	$GrandTotal= odbc_result( $cur, 10 );
	$GrandTotal=(number_format($GrandTotal, 2));

	echo "<tr>\n<td><a href='/feerev/FRSearchResults.php3?LogNum=$LogNum'>$LogNum</a></td>\n";
	echo "<td>$MerchName</td>\n<td>$LogDate</td>\n<td>$Reason</td>\n<td>$GrandTotal</td>\n</tr>\n";
	$nbrow++;
}

Anon

You're throwing out a record when you do that check to see if there are any rows to print. Try checking to see the number of rows returned instead of if there's anything in the first row, like this with mySQL:

<?php

$results = mysql_query($query);
$numOfResults = mysql_numrows($results);

if ($numOfResults == 0) {
echo "No records were returned and none were thrown out."
} else {
echo "Put records into table."
}

Anon

Thanks...Im getting closer, but odbc_num_rows keeps returning -1...

$cur=odbc_exec($cnx, "SELECT * FROM MainTB WHERE MerchantNumber = '$MerchSearch'");
$res_count = odbc_num_rows( $cur );
if ($res_count<=0 ) {
echo " <center>\nNo records found for $MerchSearch. Please continue.\n";
}
else {

echo $res_count;

any thoughts?