PHP Code:
<?php
if (isset($_POST['join'])) {
$firstname = $_POST['firstname'];
$surname = $_POST['surname'];
if(empty ($firstname) || empty ($surname)) {
echo 'You haven\'t filled in all the fields!';
} else {
$sql = mysql_query ("INSERT INTO table (firstname,surname) VALUES ('".$firstname."','".$surname."')");
echo 'Your entry has been saved to the database!';
}
} else {
// get form
}
?>