First time here? First time here? Newsletter Signup Newsletter
Login | Register | 651326 Members and growing!
Search tutorials
Author: Anthony Kid | Website:

I'm sure half of you are bewildered, wondering what in the world that coding means or does. Well, for that, I'll explain it!

First, we open a php code with :

Then, to be able to access your SQL Database, you need to include that file we saved before, the 'db.php' file, so we include it in the php file with this


Next we select all information (*) from the totalhits table in the database with this SQL:

$sql = mysql_query("SELECT * FROM totalhits");

Then, we put the information selected with the $sql variable into an array with this:

$row = mysql_fecth_array($sql);

After doing that, we assign a new variable named "newhits", which is the variable which adds a hit each time the code is triggered:

$newhits = $row['hits'] + 1;

Once we've done all of that, we UPDATE the table to the new number of hits with this:

mysql_query("UPDATE totalhits SET hits='$newhits'") or die (mysql_error());

» Level Basic

Added: 2004-09-08
Rating: 7 Votes: 10
(10 being the highest)
» Author
Good Luck! If you need help AIM me at Anthony Kid x
» Download
Download the files used in this tutorial.
» Forums
More help? Search our boards for quick answers!


  • There are no comments yet. Be the first to comment!

  • You must have javascript enabled in order to post comments.

Leave a Comment
  • Your email address will not be published. All fields are required.
Featured Flash FLA
» Author: Inocreato
» Title: RaiseTheBlocks
» Description: Raise all the blocks to win the game
Featured Sound Loops
Image for equalize

Audio Player

» Author: TomCat Carty
» Title: The Wood
» Description: Just a little game ending or it can maybe be looped. Recorders with music box and percussion to give the feel of well, I don't know, the woods? Free to use, just credit me. thank you
Latest Font
» Author: Fábio FAFERS
» Description: I created this font for free use. Everyone can apply it in personal or business texts. Its free, but I want to be communicated in case of business use. Donations are accepted to keep the project of free fonts alive! Thank you all
Featured Sound Fx
Image for equalize

Audio Player

» Author: Davisigner
» Description: Hmm... what to say about this one? It's reminiscent of the closing notes of the opening music from the Three Stooges done in a church organ style with a closing cymbal crash. I'll give this one away gratis, but feel free to check out my free loops and potential upcoming license-mandated ones over in the respective part of Flashkit.