Re: Re: PHP and MySQL bug

I'm using Windows 2000. ----- Original Message ----- From: "Cleber" <racional@constel.com.br> To: "Nuno Lopes" <nunoplopes@clix.pt> Sent: Tuesday, January 07, 2003 10:23 AM Subject: Re: [PHP] Re: PHP and MySQL bug > Try add to /etc/hosts the name and ip of DB is located > > > ----- Original Message ----- > From: "Nuno Lopes" <nunoplopes@clix.pt> > To: <php-general@lists.php.net>; <mysql@lists.mysql.com> > Sent: Tuesday, January 07, 2003 7:31 AM > Subject: Re: [PHP] 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