Using php and html forms to update a mysql database

[djcritch]

Hi,

Got a bit of a problem with form, i need to be able to update a number in a mysql database using an html form. so basically i need to increment or decrement a number using a text box and a submit button.

heres the code i got:

==============================================

<form name="input" method="get" action="select.php">
Add Stock : <input type="text" name="number1">
<input type="submit" value="+">
</form>
</pre>

<?php
$add = $_REQUEST;

// update table "goods" contents
$sql =
"UPDATE goods SET stock = stock + $add WHERE id = 1";
"UPDATE stock";
if(!($result = mysql_query($sql,$dblink))) {
print "Fail: query";
exit;
}

?>

===============================================

the code half works but you need to refresh the page and it not updating the database correctly.

also if i made a copy of this code to do the stubtraction it all goes a bit tits up

im guessing there must be a better way for me to do this ?

Someone please help! Merry christmas!

[nav33n]

Welcome to Daniweb. This isnt the right forum to post your code. Post it in php forum. Cheers!
Oh, and one more thing. when you post your code, please use [ code] .. [/ code] tags.

[jasimp]

Welcome!