$db = 'php/db/SPDB.mdb'; // path to the database
$_SESSION['dbConn'] = new COM("ADODB.connection"); // connection handler
$_SESSION['dbConn']->open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=$db"); // open the connection
$strSQL = "Select * from USERS";
$rsData = $_SESSION['dbConn']->execute($strSQL); // execute sql
.....
// second connection handler
$_SESSION['conn'] = new COM("ADODB.connection"); // connection handler
$_SESSION['conn']->open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=$db"); // open the connection
while (!$rsData->eof) {
...
$sumSQL="SELECT sum(feepaid) as Payment FROM FEETABLE WHERE idnumber=".$rsData->Fields['idnumber']->value;
$rsSum = $_SESSION['conn']->execute($sumSQL);
...
$rsData->MoveNext;
}
Has someone found an easier way of going about this, as I do not want to close/lose the first connection. Help!