+1 = +2?

[NLCJ]

Hello,

I know that the title might be a bit confusing, but I've got a problem. When I say that it has to do +1 it does +2. The code I use is located at the top of the page:

$d_websitestatistics = mysql_fetch_array(mysql_query("SELECT * FROM websites WHERE id='".mysql_real_escape_string($_COOKIE['websiteid'])."'"));
$views = $d_websitestatistics['views'];
$newviews = $views+1;
echo "UPDATE websites SET views='".$newviews."' WHERE id='".mysql_real_escape_string($_COOKIE['websiteid'])."'<br />".$d_websitestatistics['views']."<br />".$newviews;

$newviews is $d_websitestatistics + 2, even though I said it should only add 1. What is the problem?

 

Regards,

NLCJ

[Mchl]

Something simpler maybe?

UPDATE websites SET views= views + 1 WHERE id= ...

[NLCJ]

Hehe.  Tried this before but I guess I made a typo when I did it. Thanks anyway!

[NLCJ]

I think my server didn't pass its math test... It WORKED using:

mysql_query("UPDATE websites SET views= views + 1 WHERE id='".mysql_real_escape_string($_COOKIE['websiteid'])."'");

But now it also adds 2 to the value... What is going on?!

 

Regards,

 

[Alex]

Are your sure you're not accidentally running multiple queries to update the same information?

[NLCJ]

Triple checked it, nothing!

[NLCJ]

This might be useful, I don't know. If I use:

mysql_query("UPDATE websites SET views= views + 0.5 WHERE id='".mysql_real_escape_string($_COOKIE['websiteid'])."'");

it adds ALSO 2 to the value.

 

And using:

mysql_query("UPDATE websites SET views= views + 5 WHERE id='".mysql_real_escape_string($_COOKIE['websiteid'])."'");

results in adding 10 to the database. Double entries isn't a possibility since I only edited one line...

 

I'm totally confused! :S

[PFMaBiSmAd]

Your page is probably being requested twice by your browser or you are doing something else to cause that code to be included twice...

 

Are you using firefox with any debugging add-on tools?

[NLCJ]

I'm using Chrome, but do have FireFox installed.

[NLCJ]

Thanks, I think that is the reason. I'm using FancyBox to load that page, the strange thing is that when a cookie exists it shouldn't update the value. If a cookie doesn't exist it will update the value, and directly set a cookie (this means that if the page reloads it won't update the values?). I'm going to Google about it! Thanks!

[PFMaBiSmAd]

I have not heard of any cases where Chrome will request a page twice, but either your browser (due to debugging tools or to apply default character encoding), some javascript in your browser (typically some validation logic submitting a form and the actual form being submitted by the browser), your web server (if you are rewriting the url and/or some cases of an add on domain), or your logic on the server is causing this.

[NLCJ]

(typically some validation logic submitting a form and the actual form being submitted by the browser)

 

I thought this was the problem, since the form was submitting to that page and the javascript was opening that page in the FancyBox. Though the problem persists, even after removing the total 'action=' part...

 

I've checked it, and the php file is only requested once in the whole script.

[NLCJ]

I guess you were right, if I don't use FancyBox it is working. I have to search it in my JavaScript (oh, balls, just started with it yesterday).

 

Thanks a lot.

[PFMaBiSmAd]

You can typically use a session variable to prevent duplicate page requests. Set a session variable at the point where the first page request has successfully been processed and at the start of the page check if the session variable is already set and skip processing the page if it is set.

[NLCJ]

You can typically use a session variable to prevent duplicate page requests. Set a session variable at the point where the first page request has successfully been processed and at the start of the page check if the session variable is already set and skip processing the page if it is set.

 

I guess it still isn't the problem. If I've set it using sessions it shows a white page, and if you close the FancyBox and reopen it it shows the processed page. Even though it still adds 2 to the value! Strange... 

[NLCJ]

I give up... All solutions offered here will be tried (if someone feels like notifying me about another solution).

 

How do I fix it?

Simple:

I created a HTML file which refreshes after 3 seconds to the other (PHP) file, then everything will be fine...

 

Regards and thanks,

NLCJ