How can I update a MySQL database using PHP?

?indy eXtreme?

New member
More specific I have a Mysql database with 2 fields.
The first field contains number (a).
In the php a variable $b is defined.
I want to update the second field of the database so that it would contain the number a*$b. {a times $b variable defined in the php}

For example we got this table:

First | Second
12 | 36 { a*$b=12*3=36}

$b=3;

So can anyone help me with this? I tried doing a script that updates this when the page is accessed but it does it every time. I want it to do it only once but also verify if i change number $b defined in the php so it would update the value. (Say i change it to 3 to 2, 24 should be the second field instead of 36).
 
Back
Top