Can someone please help me with my insert page, my form appears but once i click the submit button to add a new player the information disappears but it doesnt update the table in mysql
please see my query below
[
Language: PHP
if(isset($_POST[';submit';])){
$sql = "INSERT INTO registration (Name, Surname, Contact Number, Email, Position, Username, Password) VALUES (';$_POST[name]';,';$_POST[surname]';,';$_POST[contactnumber]';,';$_POST[email]';,';$_POST[position]';,';$_POST[username]';,';$_POST[password]';)";
mysql_query($query);