Need help in getting a php file to add 2 numbers

[homer09001]

i run a clan and need to get a html form to add a number to a number already in the databse for that specific user!

so basically i need it to be able to search for the user in the databse that filled the form out then add a number he submitted to the the one currently in the database. if u understand

[barand]

UPDATE mytable SET colname = colname + $numberEntered WHERE user = '$user'

[jkurrle]

I am assuming that this is what you are trying to do:

1) read an item from a record from the database for a specific individual

2) Get the information that a person put into the form, so you can get the number

3) Add the number posted to the number in the database

4) Post the new number to the database

Let's see how this works

// Get information from posted form (this assumes form used POST method)
$username=$_POST['username'];
$userstat=$_POST['userstat'];

//connect to the database:
$host="localhost";
$login_name="some MySQL Login Name";
$password="Password for the Login Name";
$connection=mysql_connect($host,$login_name,$password)
  or die("Could not connect to the server");
$db=mysql_select_db("Database_Name",$connection)
  or die("could not connect to database");

// next get the info you are looking for
$select="select User_Stat from Table_Name
  where User_Name='$username'";
$result=mysql_query($select)
  or die("Select from Table_Name had errors");
$row=mysql_fetch_array($result,MYSQL_ASSOC);
if ($row<>"")
  extract($row);
else
  die("No data to extract");

//Now we add the numbers together
$User_Stat=$User_Stat+$userstat;

//now we post the new number to the database.
$update="update Table_Name set
  User_Stat='$User_Stat'
  where User_Name='$username'";
$result=mysql_query($update)
  or die("Update into Table_Name had errors");  

//finally, we close the connection
mysql_close($connection);

This sounds like it might work...

[homer09001]

ok JK good news its adding numbers kinda!! but its doubling the previous value that was in the database heres the code?:

 <?php 

// Get information from posted form (this assumes form used POST method) 
$id=$_POST['id']; 
$hours=$_POST['hours']; 

//connect to the database: 
$host="localhost"; 
$login_name="gea"; 
$password="******"; 
 $connection=mysql_connect($host,$login_name,$password) 
  or die("Could not connect to the server"); 
$db=mysql_select_db("gea",$connection) 
  or die("could not connect to database"); 

// next get the info you are looking for 
$select="SELECT hours from information where id='$id'"; 
$result=mysql_query($select) 
  or die("SELECT from information had errors"); 
$row=mysql_fetch_array($result,MYSQL_ASSOC); 
if ($row<>"hours") 
  extract($row); 
else 
  echo "No data to extract"; 

//Now we add the numbers together 
$hours=$hours+$hours; 

//now we post the new number to the database. 
$update="update information set 
  hours='$hours' 
  where id=$id"; 
$result=mysql_query($update) 
  or die("Update into information had errors");   

//finally, we close the connection 
mysql_close($connection);

?>

[homer09001]

wait i think i realise what ive done

[homer09001]

thanx cracked it now sorted the prooblem i had to rename the field in the database as it was teh same name as the form

[thorpe]

dont bother with this approuch, you are running more queries than you need to.

have a look at barand's post. ^

[jkurrle]

I think you found it already, but you declared $hours twice, first as a value you got from a POST, then again once you extracted your row. Change your first $hours variable to a different name and you'll probably be set.

[homer09001]

im nto geting any errors whatsoever but the froms are just not writing tot he database table the php files are correct they havent been chagned since yesterday and they were working fine then any ideas?