Re: Interbase queries
| From: | Wil van Lierop | Date: | Sun, 10 Aug 2003 14:59:51 +0000 |
| Subject: | Re: Interbase queries | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29799@lists.php.net to get a copy of this message | ||
Dear Evan,
It depends what you send in your SQL statement ($sqlstmt), as far as i know
Interbase need only commit-statements depending on your I-Base server
setting AUTO-COMMIT=Tue/False. And only then when you send UPDATE queries.
For SELECT statements you dont need a COMMIT. But beware that you left with
an active result set when you do not send a COMMIT.
Kind regards,
Wil
salesvast@home.nl
"Evan Morris" <evan@exclusivebooks.com> schreef in bericht
news:073101c35755$574f5740$5da429c4@TECH02...
> Hi
>
> I am new to using PHP with Interbase.
>
> If I want to issue a query, I use:
>
> $sth = ibase_query ($dbh, $sqlstmt);
>
> I am assuming this issues the query to the database, and commits at the
same
> time? Do I need to release anything after having done this, or does it
take
> care of that by itself?
>
> Thanks
>
> Evan Morris
> evan@exclusivebooks.com
> Tel: +27 11 792 2777
> Fax: +27 11 792 2711
> Cell: +27 82 926 3630
>
>