Subject Iterating through results.
Author Uwe Oeder
I am using Apache 2.0.52 , PHP 5.0.2 , Firebird 1.5.1
I am using the php_interbase.dll extension.

Question 1 :
Is there any newer version or a .dll specific for firebird ?

I prepard the following query:
$DBHandle = ibase_connect ($host,$username,$password) or
die ("error in db connect") ;

$SQLStmt = "SELECT CountryName FROM Country ORDER BY CountryName" ;
$SQLQuery = ibase_prepare($SQLStmt) ;
$SQLData = ibase_execute($SQLQuery) ;

$TotalCountry = ibase_affected_rows() ;
echo "TotalCountrys = " . $TotalCountry ;
for ($Countrys = 1 ; $Countrys <= $TotalCountrys ; $Country++)
{
$row = ibase_fetch_row($SQLData) ;
echo $row[0] ;
}

Question 2 :
There should be more than 50 records displaying but interbase/firebird
reports 0 were affected.
How do I iterate through the resultset of a query ?

Question 3 :
Where can I find all the functions available to me ?




Mr. U. Oeder
Head of IT Departement

Creative-Logic
1 Dr Michael de Kock St.
Northern Industrial Area
Windhoek
Namibia

P.O. Box 9274
Phone : 061-262 941
Fax : 061-262 130
Email : uweo@...


----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.768 / Virus Database: 515 - Release Date: 9/22/2004


[Non-text portions of this message have been removed]