Re: PHP and MySQL insert problem
| From: | Richard Lynch | Date: | Mon, 02 Apr 2001 23:34:41 +0000 |
| Subject: | Re: PHP and MySQL insert problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-46722@lists.php.net to get a copy of this message | ||
Perhaps http://php.net/FAQ.php#4.4 is the answer.
--
Visit the Zend Store at http://www.zend.com/store/
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
----- Original Message -----
From: "Pinwang Chao" <tchao@Worldnet.att.net>
Newsgroups: php.general
Sent: Sunday, March 25, 2001 6:36 PM
Subject: [PHP] PHP and MySQL insert problem
> Can any one help me with the following problem?
>
> I have a very simple query:
>
> ...
> $sql="insert into tt (a, b) values ('1', '2')";
> $result=mysql_query($sql);
> ...
>
> I always got the following error message when I run it from my browser.
>
> Warning: MySQL: Unable to save result set in
/usr/local/apache/htdocs/tt.php
> on line 9
>
> But even with this message, the values are still inserted into tt.
>
> When I change $sql to &sql="select * from tt";
>
> There were no such error message.
>
> It puzzled me? Why?
>
> My system: PHP 4.0.4pl1, MySQL 3.23.32
>
> Thanks in advance.
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>