Problem Code UPDATE MYSQL PHP

Question

Someone could confirm me if the code below is correct, I’m not good in php or mysql, I just do arrangements and I’m not getting the expected result, the connection with db is correct, no errors(exite um if for error)...

The expected result is when fill in the html "name" is inserted 100000 into the Columa paymoney WHERE name=name

full code http://pastebin.com/Y65ThtnK

<?php
ob_start();
session_start();

include_once 'dbcon.php';

if(isset($_POST['btn-signup'])) {

 $name = trim($_POST['name']);



 $name = strip_tags($name);



 // paymoney encrypt using SHA256();


 // check usuario dup
 $query = "UPDATE player SET paymoney='10000'
           WHERE name ='$name'";


}
?>

Answer 1

To be executed.

$query = "UPDATE player SET paymoney='10000'
           WHERE name ='$name'";
$suaconexao -> query($query);

Answer 2

Put sql like this:

$query = "UPDATE player SET paymoney='10000'
           WHERE name = ".$name;