On Fri, 31 Jul 2009 07:54:13 -0400, Dan Shirah wrote:
>> How does that work considering that mysql_query() only
>> returns true or false on INSERT? I'd expect the script
>> to fail on $result not being a valid resource.
> I don't know about mysql as I work with MSSQL Server and Informix, but for
> me it works like this:
> $insert = ifx_prepare("INSERT INTO my_table
> VALUES ('0')", $connect_id);
> ifx_do($insert) or die ("Query failed");
> By using PREPARE and DO to execute the queries it allows ifx_free_result to
> release those resources.
That explains it. (You'd have to use the MySQLi extension
to use prepared statements with MySQL, unless I'm confused).
Personally, I try to make it a point to free resources as
soon as possible.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php