button to add one to database total

You had the right idea to use a form,
use the update record wizard, this will generate the update sql required at the top of your page. You will need to modify this code slightly by adding +1 .

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE table_name SET temascore= broker_rating + 1",
GetSQLValueString($_POST['teamscore'], "int"));

Your form hidden field should be similar to
<input type="hidden" name="teamscore" value="<?php echo $row_nameofrecordset['teamscore']; ?>">

all this is assuming you havea field in your db named teamscore.

hope this helps a little

Thanks for that.

On that basis the code should be

UPDATE teamnames
SET teamscore= teamscore +1;

but how do I turn that into a button on the page?

I've tried using a form and including this code as a hidden field but it didn't work and I'm sure that's too much of a complicated method?

Can you (or anyone else) suggest a better way of doing it so that I can simply click and button or even textlink to apply the code?

Cheers


Tubby