Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

[PHP-DB] php4.0.4 and Interbase - fetching records across files From: Greg Kelley (gkelley <email protected>)
Date: 01/08/01

I'm trying to fetch multiple records, one at a time (like I have done with MySQL and PostgreSQL) by storing the result set id to a session id. Then I recall the same php file using a Next Button and get the next record from the result set. Interbase doesn't like this at all. It stores a 0 to the result set session variable - it's like it disconnects after one fetch! Here is a bit of code to illustrate:

if ($site != "Next") {
$sql="SELECT * FROM COMPANY_SITES LEFT JOIN COMPANIES ON COMPANY_SITES.CMP_AUTO_KEY = COMPANIES.CMP_AUTO_KEY WHERE COMPANIES.CV_UDF_013='".$pass."' ORDER BY SITE_DESCRIPTION";
$conn = ibase_connect ($host, $user, $pwd, 'ISO8859_1', 100, 1);
$qry = ibase_prepare ($conn, $sql);
$rslt = ibase_execute ($qry); <- Result id#3 is the value of $rslt here
$rcd = ibase_fetch_object ($rslt);
} else {
$rcd = ibase_fetch_object ($rslt);
}
<- zero (0) is the value of $rslt here after one fetch!

Here is the Button:

<form action='cssite.php' name='Track'>
<p><input type="submit" name="site" value="Next">
</form>

The first time the .php file is called, it processes the whole connection. Each time thereafter, it should just do a fetch based on the stored $rslt value (stored in the usual session variable way).

Does anyone know of a 'correct' way to fetch multiple records one at a time over different .php files?

Thanks for any insights - this one has me stumped...

________________________
Greg Kelley, IT Director
Londavia, Inc.
Pease Int'l Tradeport
68 New Hampshire Ave.
Portsmouth, NH 03801
603.766.3005
http://www.londavia.com
SSA, EAA, AOPA, N5506M