Re: Re: PHP and MySQL bug

I have the latest version of PHP (4.3.0) as module in apache 2.0.43 and mysql 3.23.49. Everything is working fine, except this. With pconnect the error is the same! ----- Original Message ----- From: "Larry Brown" <larry.brown@dimensionnetworks.com> To: "MySQL List" <mysql@lists.mysql.com> Sent: Monday, January 06, 2003 6:28 PM Subject: RE: [PHP] Re: PHP and MySQL bug > This definitely sounds like a buggy installation or there may be some > problem with the communication between the web server and the mysqld. Is > the db on a different machine? Try using mysql_pconnect instead of connect > just to see what result you get. I have read some unfavorable statements > about using pconnect with a large number of hits so if it works you should > read the comments about it on php.net. Do a search for mysql_pconnect. > > Larry S. Brown > Dimension Networks, Inc. > (727) 723-8388 > > -----Original Message----- > From: Nuno Lopes [mailto:nunoplopes@clix.pt] > Sent: Monday, January 06, 2003 1:09 PM > To: MySQL List; php-general@lists.php.net > Subject: [PHP] Re: PHP and MySQL bug > > The problem is if I close the connection and reopen it the query is done, > but if I remain with the same connection has the previous query, mysql > returns an error. > > > ----- Original Message ----- > From: "Larry Brown" <larry.brown@dimensionnetworks.com> > To: "MySQL List" <mysql@lists.mysql.com> > Sent: Sunday, January 05, 2003 4:16 PM > Subject: Re:PHP and MySQL bug > > > > Try replacing the following line... > > > > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this > > query doesn't > > work!!!! > > > > With... > > > > $query = "UPDATE d SET h='$h' WERE id='$id'"; > > $queryr = mysql_query($query) or die("The sql statement does not > execute"); > > > > if(mysql_affected_rows() !== 1) > > { > > die("The sql statement is successfully run however either h did not > > change or there is an internal error. Try executing the sql from the > > command line to make sure it otherwise works."); > > } > > > > and see which is coming back. > > > > > > Larry S. Brown > > Dimension Networks, Inc. > > (727) 723-8388