PHP - insert into database

1

Hi everyone,

I made a simple form that is supposed to insert members on DB.


 <form method="POST" action="script.php">
    
Name
<input name="Name" type="text" size="50" maxlength="50" name="user" />
        
            
Email
<input name="Email" type="text" size="50" maxlength="50" name="email"/>
            
<input type="submit" name="submit" id="submit" value="Submit">
<input type="reset" value="Limpar">
            
</form>

Now, on my script.php page I have the rest of the code:


<?php
include ("connection.php");

    if(isset($_POST['submit'])) {
    
    $user = $_POST['user'];
    $email = $_POST['email'];

$sql="INSERT INTO clients (name, email) VALUES ('$name','$email')";
            
            $result = mysql_query($sql);
            
            if(!$result) {
            {
                 die('Error: ' . mysql_error());
                 
            } else {
            
            echo "<p>Done!.</p>";
            
            }
        
        mysql_close($connection);
    }

?>

Everything is in order and the folder structure is correct, however, it seems that it never enters the script.php page, I tried flags and got nothing.

Any thoughts?

Thanks in advance.