hey i use this in sql
UPDATE userStats SET US_money = US_money + 10
to give all users 10 more money
but how do i do it if i want to add 5% to the value
also if money on my acc is $4,555 and i want to add 5% = 4555 + 5% = 4782
How can i do it?
$db_host = "localhost";
$db_user = "root";
$db_pass = "1234";
$db_name = "root";
$connect = @mysql_connect($db_host,$db_user,$db_pass);
//here i want the query to add 5 percent
$query = "UPDATE userStats SET US_money = US_money + 5";
when i go to localhost/5percent.php iwant it toadd 5% to all users money how can i do it?
hope you understand and can help me