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 =/
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 =(
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 =(