Insert page

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);

Have you connected to the database ?
(You should only connect if isset($_POST)) is true and your data validates).


You will never succeed with your SQL query if you put your SQL into a variable named $sql and then use a variable named $query in your query.

Where does $query come from ?

Should be -

mysql_query($sql);