MySQL's "UPDATE" being called twice.. And others

SineCosine

I'm still looking for my Tangent
Reaction score
77
Yea..
I think MySQL is deliberately screwing with my mind -____-
I've been trying to figure out the problem for the past hour.

Okay, here's what I am trying to do:
When a task is complete, a form is sent to a php and the php increases the value of a counter, Complete, by 1.
When a task is incomplete, same thing, but Incomplete goes up by 1.

And when a task starts, Started goes up by 1.

When I submit the 'Started' form..
All seems well.
Until I close the webpage that holds the form.
Then, it seems that it gets called AGAIN.

Ugh.
Also, calls are being made to increase the value of a variable when it should not be possible.. At All.

Here's the code, maybe I did something wrong =/

Code:
<?php
	include('Config.php');

	$Report_Type = $_POST['Report'];
	$Report_User = $_POST['User'];

	if ($Report_Type == 'Start') {
		mysql_query("UPDATE EZ_Registered SET Started=Started+1 WHERE Username='$Report_User'");
	} else if ($Report_Type == 'Incomplete') {
		mysql_query("UPDATE EZ_Registered SET Incomplete=Incomplete+1 WHERE Username='$Report_User'");		
	} else if ($Report_Type == 'Complete') {
		mysql_query("UPDATE EZ_Registered SET Complete=Complete+1 WHERE Username='$Report_User'");	
	}
?>

When I submit 'Start', Start goes up by 1.
Then, I close the webpage that holds the form.
Then, Start and Incomplete go up by 1.

So, the end result is: Start = 1, Incomplete = 1
But Incomplete should still be zero because no call was made to it.. Ever.

I even ran a few checks, the php that processes the form will display an 'alert' whenever it is loaded.
An alert will run whenever I press submit.
I added a counter to see how many calls the database was getting.

End result:
PHP processes: 2
Forms submitted: 2
MySQL Counter: 4

It seems that everything get's called twice when it should only happen once =(
 

perkeyone

something clever
Reaction score
71
when ever i get really crazy errors it tends to be because i used the same variable name in two places
or i forgot to put quotes around something
or i forgot the $ in front of a variable name.
the code you posted looks pretty solid so im guessing the error is somewhere else.
 

SineCosine

I'm still looking for my Tangent
Reaction score
77
Actually, I did find it.. eventually.
It wasn't the codes, but some weird buggy issue with DOM Content.

I thought the update was being called the second time when I remove the form.
But that's because I move the form, then close it.

Turns out, the very act of moving it caused it to get sent again (For reasons I'll never understand).
So, I just stopped moving it.. And anything that would cause it to move.
(I gave it an absolute position xD)
 
General chit-chat
Help Users
  • No one is chatting at the moment.

      The Helper Discord

      Staff online

      Members online

      Affiliates

      Hive Workshop NUON Dome World Editor Tutorials

      Network Sponsors

      Apex Steel Pipe - Buys and sells Steel Pipe.
      Top