I cannot get my php file to post data to my database.

I have followed the directions from the article "Using PHP to INSERT data into a database" that is posted in your support center but the form will still not post data to the database.
I can connect to the database and had the support center verify that I can connect. I think there may be something wrong with my SQL command but cannot figure it out.

I am working in Dreamweaver CS5 and setup the database on the cpanel using the MySQL Database Wizard.

Here is part of my PHP code:
{
$connection = mysql_connect($hostname, $username, $password);
mysql_select_db($dbname, $connection);

//setup posting to the database
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$title = $_POST['title'];
$company = $_POST['company'];
$address = $_POST['address'];
$address2 = $_POST['address2'];
$city = $_POST['city'];
$state_province = $_POST['state_province'];
$postal_code = $_POST['postal_code'];
$country = $_POST['country'];
$phone = $_POST['phone'];
$fax = $_POST['fax'];
$email = $_POST['email'];

$firstname = htmlspecialchars($firstname);
$lastname = htmlspecialchars($lastname);
$title = htmlspecialchars($title);
$company = htmlspecialchars($company);
$address = htmlspecialchars($address);
$address2 = htmlspecialchars($address2);
$city = htmlspecialchars($city);
$state_province = htmlspecialchars($state_province);
$postal_code = htmlspecialchars($postal_code);
$country = htmlspecialchars($country);
$phone = htmlspecialchars($phone);
$fax = htmlspecialchars($fax);
$email = htmlspecialchars($email);

$query = "
INSERT INTO 'dadcon5_calculator'.'Registration' ('firstname','lastname','title','company','address','address2','city','state_province','postal_code','country','phone','fax','email') VALUES ('$firstname','$lastname','$title','$company','$address',$address2','$city','$state_province','$postal_code','$country','$phone','$fax','$email');";

mysql_query($query);

//execute the SQL statement
if (mysql_query($sql,$connection)) {
echo "record added";
} else {
echo "fubar";
mysql_close($connection);
}