Posted by thomasp on 11/15/82 11:26

This returns the value of the $transid variable everytime.

$sql = "SELECT COUNT(*) FROM tblTransaction WHERE TransID = '$transid'";
$query = odbc_prepare($conn,$sql) or die("ERROR");
if ($NumRecords=odbc_num_rows($query)<=0) {
$NumRecords = 0;
odbc_fetch_row($query,0);
while (odbc_fetch_row($query))
{
$NumRecords++;
}
odbc_fetch_row($query, 1);
}
return $NumRecords;

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

• Next in forum: Re: PHP and MS Access Record Count
• Prev in forum: Re: PHP and MS Access Record Count
• Thread view: Re: PHP and MS Access Record Count

[Reply to this message]