arrowarrow Shoutbox
 
info In this area you may insert brief and quick contents that you do not deem fit or sufficiently relevant to be placed in your blog. Add new contents: click here
 
arrowarrow Currently available topics
 
Viewing only topics of: A All topics: click here
All topics: 104
Sender: A

A MySQL Programming Mystery? Database Updated Value Increased By More Than Expected 1

http://en.wikipedia.org/wiki/File:Miniaturk_009.jpg Topic: 40 permalink
Visits: 2,526
You have a website.  
You keep track of visits.  
Each time a vistor visits a page you update your database visits for that page by 1.  
Yet, alas! The field is always updated by some value higher than 1.  
Is there a bug in mySql?  
Nope, wrong questions.  
Right question: do you have advertisments on your pages?  
Oh, you do?  
 
Cool, there may be a robot following your pageloads, summoned by the ads loaded together with the page - thence the multiple visits, particularly the first time you visit a new page or if you visit it again after a pause: the robot may visit it once and be quiet for a while; then, solicited by several pageloads (of the ads included in the webpage), suddenly it may arrive again!
Cast your vote for this topic. «Negative Positive»
Click here to save your vote
Current average: 0.00, Voters: 0
Insufficient form parameters: you forgot to fill in some field/s You must reload the page to view the updates You did not cast a vote. You need to cast a vote by selecting a radio button. Impossible to proceed