sql insert problem

Can anyone tell me why this is not working?

[code=php] <?php
include(“db.php”);
$name = $_POST[‘name’];
$address1 = $_POST[‘address1’];
$address2 = $_POST[‘address2’];
$city = $_POST[‘city’];
$state = $_POST[‘state’];
$zip = $_POST[‘zip’];
$country = $_POST[‘country’];
$acode = $_POST[‘acode’];
$numb = $_POST[‘numb’];
$companytype = $_POST[‘companytype’];
$R1 = $_POST[‘R1’];
$tst1 = $_POST[‘tst1’];
$caribcountry = $_POST[‘caribcountry’];
$comments = $_POST[‘comments’];

if (isset($name)) {
$q = “INSERT INTO caribbean(name, address1, address2, city, state, zip, country, acode, numb,
companytype, R1, tst1, caribcountry, comments) VALUES (‘$name’, ‘$address1’, ‘$address2’, ‘$city’, ‘$state’,
‘$zip’, ‘$country’, ‘$acode’, ‘$numb’, ‘$companytype’, ‘$R1’, ‘$tst1’, ‘$caribcountry’, ‘$comments’)”;

}
echo “1 record added”;
?>[/code]

Also in #PHP _↴