MYSQL php update adding extra number

[lucas20]

Wondering if anyone knew why the following code was adding +2 instead of +1.  It is out of all while/loop statements.  Each of the echo statements appear once and are correct (add only one to the next week).  However, looking at the database it jumps say from week 2 to week 4 instead of week 2 to week 3

 

	$currentweek = mysql_result(mysql_query("SELECT week from WEEK WHERE week>0"),0);
	echo $currentweek;
	$newweek=$currentweek+1;
	echo "<br>New week: $newweek<br>";
	$query7 = "update WEEK SET week=$newweek WHERE week>0";

	mysql_query($query7) or die('Week update failed:' . mysql_error()); ;
$value = mysql_result(mysql_query("SELECT week from WEEK WHERE week>0"),0);
	echo "<center><h2>Week updated as well $value</h2>";

[Maq]

You need to use:

 

strtotime('+1 week');

[lucas20]

That's not it, it is just an integer, not a part of the php time functions

[Maq]

If it's an integer, why don't you just add 1 inside the query?

 

$query7 = "update WEEK SET week=week+1 WHERE week>0";

[lucas20]

ya i tried that too, same thing bumps it by 2 - i added the variable so that i could troubleshoot

[Maq]

Try this:

 

$query7 = "update WEEK SET week=week+1 WHERE week > 0";
mysql_query($query7) or die('Week update failed:' . mysql_error()); ;
$value = "SELECT week FROM WEEK WHERE week > 0";
$result = mysql_query($value) or die(mysql_error());
while($row = mysql_fetch_array($result)) {
     echo "Week updated as well " . $row['week'] . "";
}

[Maq]

MISTAKE (extra semi-colon, but I'm sure you would have figured that out  ), change this line to:

 

mysql_query($query7) or die('Week update failed:' . mysql_error());

[PFMaBiSmAd]

Your browser is probably requesting the page twice. What browser are you using? Exactly how is the page being requested, a link, a form submission?

[fenway]

Your browser is probably requesting the page twice. What browser are you using? Exactly how is the page being requested, a link, a form submission?

Sigh... don't people use redirects?