Simple PHP / Mysql form !!

[Kinetic_Mix]

I am looking some PHP help with a simple email signup script !

I have created a mysql database with the following fields : ID, Name, Email and MobileNo

What I want to do is have a form on my website which will collect all these details and then validate the data to make sure that all fields have been filled in with the correct data, however Mobile number is not a compulsory field so does not have to be filled in. When the data has been validated and is correct then I want to add this record to my database called, newsletter in a table called signup. Once this has been done then you will be directed back to the same page you signup from.

I know this is a simple thing to do, but I have never done any PHP coding before and I am looking for some guidance on how to create the script or if anyone can post some code that would do what I am needing then I would be grateful !

[Immo]

Not tested the below script, I just wrote it but it should work. Make sure you have ID in the database set as auto_increment. Also make sure the form text box names are "email", "name", "mobile".

Any errors let me know and I will fix it.

<?php
if (isset($_POST) {
if ($_POST['email'] && $_POST['name'] && $_POST['mobile'] != "") {
$sql = mysql_query("SELECT * FROM `table_name` WHERE `NAME` = " . $_POST['email'] . " LIMIT 1");
$rows = mysql_num_rows($sql);
if ($rows == "1") {
echo ?>
<p>Sorry that email address has been used to register here before, please try another.</p>(INSERT FORM AGAIN HERE)
<?php ;
}
else {
$ins = mysql_query("INSERT INTO `table_name` (`ID`, `Name`, `Email`, `MobileNo`) VALUES ('', '" . $_POST['name'] . "', '" . $_POST['email'] . "', '" . $_POST['mobile'] . "'));
echo ?>
<p>Thanks for registering... You have been added to our database.</p>
<?php ;
}
}
else {
echo ?><p>You did note complete all fields in the form please try again.</p> (INSERT FORM AGAIN)
<?php ;
}
else {
echo ?>
(INSERT FORM HERE)
<?php ;
}
?>