[DisneyFan25863]

Ok, I've been thinking about how to do this for some time, but can't figure it out. I basically want to have a number stored in a MySQL Database, which can be added or subtracted to from a webpage, then displayed on another. So Basically, the script would be like this. I would put in a query string for each number, (like www.whatever.com/number.php?changenumber=yes, but I already know how to do that). I would then have it so that there would be an option with two buttons (one that says add, one that says subtract), and then a text field for a number. So, for instance, if I wanted to subtract 4 , it would go like this:

I would select the button for "subtract" on the form, then enter "4" in the text field. Clicking submit would go to a php script that would put it in a database. This is where I need help. What should I put for the script?
Something like this?

PHP Code:

<?php

$conn = mysql_connect("localhost", "user", "pass");

mysql_select_db("DB",$conn);

$sql = "INSERT INTO Table values ('', 'What to put here?')";

if (mysql_query($sql, $conn)) {

     echo "record added!";

} else {

    echo "something went wrong";

}

?>

If I were to just use a "$_POST[field]')" there, it would replace the number, right? So does anyone know what I should put?

Thank You!

[dotbob]

Originally Posted by DisneyFan25863

If I were to just use a "$_POST[field]')" there, it would replace the number, right? So does anyone know what I should put?

Thank You!

Why can't you extract the number out of the db to do work on it?

[NeverMind]

your code is good ..

PHP Code:

<?php 

$number=$_POST['number'];//get the number from POST

settype($number, "integer");//make sure it's a number not a string ..

$conn = mysql_connect("localhost", "user", "pass"); 

mysql_select_db("DB",$conn); 

$sql = "INSERT INTO Table values ('', number=number-$number)";

/*notice that you don't need any quote here just call 'number' from database

and use it again in the same query and substract

$number from it .. ot use any other algebra ..*/

if (mysql_query($sql, $conn)) { 

     echo "record added!"; 

} else { 

    echo "something went wrong"; 

} 

?>

[DisneyFan25863]

Originally Posted by NeverMind

your code is good ..

PHP Code:

<?php 

$number=$_POST['number'];//get the number from POST

settype($number, "integer");//make sure it's a number not a string ..

$conn = mysql_connect("localhost", "user", "pass"); 

mysql_select_db("DB",$conn); 

$sql = "INSERT INTO Table values ('', number=number-$number)";

/*notice that you don't need any quote here just call 'number' from database

and use it again in the same query and substract

$number from it .. ot use any other algebra ..*/

if (mysql_query($sql, $conn)) { 

     echo "record added!"; 

} else { 

    echo "something went wrong"; 

} 

?>

Shouldn't it be

PHP Code:

<?php 

$number=$_POST['number'];//get the number from POST

settype($number, "integer");//make sure it's a number not a string ..

$conn = mysql_connect("localhost", "user", "pass"); 

mysql_select_db("DB",$conn); 

$sql = "INSERT INTO Table values ('', number=number+$number)";

/*notice that you don't need any quote here just call 'number' from database

and use it again in the same query and substract

$number from it .. ot use any other algebra ..*/

if (mysql_query($sql, $conn)) { 

     echo "record added!"; 

} else { 

    echo "something went wrong"; 

} 

?>

(See the "+" insted of the "-"). So, if they wanted to add a number to it, lests say 53 it would be number+53. If they wanted to subtract a 53, it would be number+-53. Would that be right?

[NeverMind]

try ,,
I am not sure if using - after + is legal in php ... but try ..