A very tricky mystery

Ender2222

:bemused:
I have one of those problems where my code works perfectly on my localhost, however when I upload it to my webhoster something very strange and unexplainable happens. Its quite the mystery that has been racking my brain all day. Heres whats going on.

My Code:

 
               if($canvote)
	  {
		  $rating = $row_Recordset1['EpicPoints'];
		  $rating+=$vote;
		  $t = "UPDATE epiclink SET EpicPoints = $rating WHERE ID=$colname_Recordset1"; 
		  mysql_query($t, $EpicDatabase) or die('Error, query failed'); 
	  }

Now on my localhost this code grabs the entry's current Epic Points in $rating, ads in the value for $vote and updates properly.
On my webhost it does the same except it adds double the points

Now obviously my first guess was that this code is getting executed twice. This doesnt seem to be the case as I added an alert("going here") and tested it out. The alert was only ever called once.

Another possibility is that $rating is getting calculated improperly before the update is being called. But I did an alert($rating) and verified that the value is correct.

Some additional info. To vote, users click an image on the page, which refreshes the page and passes in ?Vote=5 to the url. My php grabs this variable checks if the user can vote, and if they can the above is executed.

One I click the link once I dont do anything! (to make sure im not causing something else to happen) and I check my database, and indeed double the points are added instantly.
🙁
Now normally this would probably be a stupid logic mistake somewhere on my part, but I want to repeat that this works perfectly on localhost, only when uploaded to the webhost it messes up. As far as I know the only difference should be various PHP settings and stuff like that which my webhost uses.

Any ideas on what could be causing this? If you can figure it out in my mind you will be an official PHP genius.

TheDefender

Just for giggles, what happens if you change to this?

if($canvote)
	  {
		  $rating = $row_Recordset1['EpicPoints']+$vote;
		  $t = "UPDATE epiclink SET EpicPoints = $rating WHERE ID=$colname_Recordset1"; 
		  mysql_query($t, $EpicDatabase) or die('Error, query failed'); 
	  }

Weedpacket

Or, if I'm guessing right about where that $row_Recordset1 value is coming from,

$t = "Update epiclink set EpicPoints = EpicPoints+$vote where ID=$colname_Recordet1";
mysql_query($t, $EpicDatabase) or die('Error, query failed');

Ender2222

Sorry guys I tried both of these and have the same results.
It seems somehow this code is being executed twice.
One time I tried adding vote/2 instead of vote.
When I passed in a vote of 3. The site was updated with a vote of 2.
Therefore it must have been doing: (3/2 + 3/2) = 2
So it must be executing that code twice somehow.

This wouldnt be so bad to figure out except when I place an Alert at that spot of the code, the alert only ever executes once. So its like its doing the code twice at once or something.

I'm totally stumped.

halojoy

the problem is obviously not in the code you shown

maybe you should show the complete sequence where $vote is processed
from when this value is first assigned
which I suppose is from the $_POST array

Weedpacket

Ender2222 wrote:
This wouldnt be so bad to figure out except when I place an Alert at that spot of the code, the alert only ever executes once. So its like its doing the code twice at once or something.

How are you placing an "alert"? If this is a Javascript alert then you'll need to recall that all of the server side processing is done before any Javascript is run on the browser.

For more debugging fun,

          mysql_query($t, $EpicDatabase) and die('Query "'.$t.'" executed.');

Wait for it to die and see what's in the database.