RE: [PHP-DB] Another Interbase question

yves, Start the transaction with ibase_trans() before you call ibase_execute. As to how is it possible, I don't really know for sure. I would presume it has to do with how Interbase handles transactions. Frank ------------------------------ Franklin J. Balak Jr. Quality Assurance Data Analyst Brown Printing Company Waseca Division Waseca, MN. 56093 Voice: 507-835-0253 Fax: 507-835-0293 ------------------------------ -----Original Message----- From: Yves Glodt [mailto:y.glodt@vo.lu] Sent: Thursday, August 23, 2001 14:11 To: php-db@lists.php.net Subject: [PHP-DB] Another Interbase question Look at this: <?php include('include.php'); $dbh = connectdb(); $sth = ibase_prepare('INSERT INTO LOG (DATETIME,REMOTE_ADDR,HTTP_HOST,QUERY_STRING,HTTP_USER_AGENT,REQUEST_URI,HTT P_REFERER) VALUES (?,?,?,?,?,?,?)'); ibase_execute($sth, $now, $HTTP_SERVER_VARS['REMOTE_ADDR'], $HTTP_SERVER_VARS['HTTP_HOST'], $HTTP_SERVER_VARS['QUERY_STRING'], $HTTP_SERVER_VARS['HTTP_USER_AGENT'], $HTTP_SERVER_VARS['REQUEST_URI'], $HTTP_SERVER_VARS['HTTP_REFERER']); ibase_commit(); ibase_close($dbh); ?> when it gets called, and I do a select in isql, I do not see any of the records. Only after doing a "manual" commit in isql, I can see the new data. How is that possible? yves -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net