Re: Information not always saved in MySQL when too slow

From:	Paul van der Vlis	Date:	Thu, 10 Oct 2002 08:15:57 +0000
Subject:	Re: Information not always saved in MySQL when too slow
References:	1	Groups:	php.windows
Request:	Send a blank email to php-windows+get-16306@lists.php.net to get a copy of this message

Paul Van Der Vlis wrote:

Hello, I have problems with some pages which work fine under Linux (with different program versions). The problem is, that when I am too slow (5 minutes?), the information from a PHP page is not always saved in the MySQL database. Does somebody know more about this problem? PHP 4.06 Apache 1.3.20 MySQL 3.23.34 With regards, Paul van der Vlis.

Hello, I have the following extra information: When I use "if($result = mysql_query($sql)) { }" twice, it will always save in de MySQL database: ----

      #update record
      $sql ="UPDATE $usetablegoals SET SecGain = '$qSecGain' WHERE GoalID = '$GoalID'";
      if($result = mysql_query($sql))  { }
      if($result = mysql_query($sql))  { }

---- With regards, Paul van der Vlis.