i want to update my sql many times and for that i am creating a script.
i created a from with things that need to be updated.
i tried this coding:

PHP Code:

$f=mysql_db_query("database_name","SELECT runs FROM table_name WHERE player=$_POST[name]");mysql_db_query("database_name","UPDATE table_name SET runs=$f+$_POST[runs] WHERE player=$_POST[name]"); 


when i use this runs are updated but the are not added with previous data.
actually i have problem with SELECT as well
like if:
runs=1
$_POST[runs]=5
updated runs=5
can anyone help?

UPDATE table_name SET runs=runs+".intval($_POST['runs'])."

PHP Code:

mysql_db_query("database_name","UPDATE table_name SET runs=runs+$_POST[runs] WHERE player=$_POST[name]");