Forms

[trinitywave]

HI all In a conflict here:

Does anyone know how to create an insert form that does this:

one of my fields in my table holds the points that this customer has accumilated. the way i have my insert form now is that it displays how may points the customer currently has, and then you have to change it adding it in your head yourself. is there any way to set that update form so you can enter the points he got today and it will add it to the value that is currently in the database!!!!!!!!!!!!!!

If somebody knows or knows a tutorial on this please let me know!

[parawizard]

enter the points in the form use a submit button that goes to a processing php file then pull the form out by using its name

$_POST['namehere'];

then pull the old value from the database VIA sql query into a variable

then add the values into a varible

$total = $_POST['namehere']+$old

then use a update query.

$query = "UPDATE TABLENAMEHERE SET FIELDNAMEHERE ='$total' WHERE PERSON='name'";
mysql_query($query);

[dave420]

or, just:

$sql="UPDATE [i]table[/i] set points=points+".$score." where id=".$id;