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="+">

$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";



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!

Recommended Answers

All 3 Replies

<form name="form" method="post" action="test.php">
Number: <input type="text" name="number"><br />
<input type="submit" name="add" value="+"><input type="submit" name="subtract" value="-">
	$query="update goods set stock=stock+$add where id=1";
	mysql_query($query) or die("Cannot update");
	$query="update goods set stock=stock-$subtract where id=1";
	mysql_query($query) or die("Cannot subtract");

Umm.. you forgot to put your code in [ c o d e ] [ / c o d e ] tags. Anyways, I hope this helps.

Thanks mate that sorted it for me!

:) you are welcome!

commented: Dont give up, keep the spirit of helping. Sometimes i wish if i was like you +3
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.