Increment Number

[Dysan]

How do I create a link, that when clicked, increments a number value stored in a database?

[GingerRobot]

If you want to do this without reloading the page/redirecting, you'll have to use AJAX. Google AJAX and you'll see that you'll make javascript make a request to a php page which can handle the query to your database.

[Dysan]

No, I want to reload the page each time. How do I create the links etc?

[pocobueno1388]

You can create the link like this

<a href="your_url.php?action=add">Click</a>

 

Then on "your_url.php" put this code

 

<?php

if (isset($_GET['action']) && $_GET['action'] == 'add'){
   $query = "UPDATE table SET number=number+1 WHERE condition";
   $result = mysql_query($query)or die(mysql_error());
   echo "DB updated";
}

?>