Re: weird errors w/ php4 and inserts/deletes
| From: | Rasmus Lerdorf | Date: | Thu, 01 Jun 2000 23:07:36 +0000 |
| Subject: | Re: weird errors w/ php4 and inserts/deletes | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-161@lists.php.net to get a copy of this message | ||
It is just warning you that you are throwing away the result that
mysql_query() may be returning. Kind of a silly warning actually given
the fact you are not doing a select. But I bet if you did:
$result = mysql_query(...)
the warning would go away.
-Rasmus
On Thu, 1 Jun 2000, Patrick Reagan wrote:
> I have the following set in my php.ini file:
>
> error_reporting = E_ALL & ~E_CORE_WARNING & ~E_USER_WARNING &
> ~E_COMPILE_WARNING
>
> So when I execute this script:
> <?
> $iDBLink = mysql_connect($gDBHost, $gDBUser, $gDBPass);
> mysql_select_db($gDBName);
>
> $strQuery = "delete from manual";
> mysql_query($strQuery, $iDBLink);
> ?>
>
> I get the following error:
> Warning: MySQL: Unable to save result set in
> /home/httpd/htdocs/admin/pageorder.php on line 7
>
> The script executes and executes the delete (and subsequent inserts)
> just fine, and all info is updated in the correct table.
>
> I went and changed php.ini to read:
> error_reporting = E_ERROR
>
> and that seemed to get rid of these warnings.
> My question is, was this a good idea? will I miss anything that is
> important in terms of warnings? Is there something wrong w/ my use of
> this script that I may have missed?
>
> tia.
> p.
>
>