Re: Freeing Memory
| From: | Dan Shirah | Date: | Fri, 31 Jul 2009 11:54:13 +0000 |
| Subject: | Re: Freeing Memory | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-296105@lists.php.net to get a copy of this message | ||
>
> 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");
ifx_free_result($insert);
By using PREPARE and DO to execute the queries it allows ifx_free_result to
release those resources.