I am getting a mysql syntax error when I try and submit my data. I suspect I have missed something but for the life of me I can’t figure what. Any one got any ideas please?
[php]<?php
if (isset($_POST[‘submit’]))
{
$city = ($_POST['city']);
$parish = ($_POST['parish']);
$place = ($_POST['place']);
$first = ($_POST['first']);
$middle = ($_POST['middle']);
$surname = ($_POST['surname']);
$age = ($_POST['age']);
$age_type = ($_POST['age_type']);
$sex = ($_POST['sex']);
$occupation = ($_POST['occupation']);
$bsc = ($_POST['bsc']);
$birth_country = ($_POST['birth_country']);
$reference = ($_POST['reference']);
$location = ($_POST['location']);
//$source = ($_POST['source']);
//add sender email as source
//calculate birth year
$frm_year="1841";
if ($age_type == "years"){
$year= $frm_year - $age;
}
else {
$year = $frm_year - 1;
}
$b_year = "abt " . $year;
//assign source from login id
$source = "[email protected]";
$first = mysql_real_escape_string($first);
$middle = mysql_real_escape_string($middle);
$surname = mysql_real_escape_string ($surname);
$age = mysql_real_escape_string ($age);
$age_type = mysql_real_escape_string($age_type);
$sex = mysql_real_escape_string($sex);
$b_year = mysql_real_escape_string($b_year);
$occupation = mysql_real_escape_string($occupation);
$place = mysql_real_escape_string($place);
$parish = mysql_real_escape_string($parish);
$city = mysql_real_escape_string($city);
$bsc = mysql_real_escape_string($bsc);
$birth_country = mysql_real_escape_string($birth_country);
$reference = mysql_real_escape_string($reference);
$location = mysql_real_escape_string($location);
$source = mysql_real_escape_string ($source);
//$image = mysql_real_escape_string ($newimage);
//add sender email as source
//Add document reference to front
$reference = $sr . $reference;
//Now we have all the data insert it into the database
$sql="INSERT INTO 1841census (first, middle, surname, age, age_type, sex, b_year, occupation, place, parish, city, bsc, birth_country, reference, location, source, )
VALUES
('$first','$middle','$surname', '$age', '$age_type', '$sex', '$b_year', '$occupation','$place','$parish','$city','$bsc', '$birth_country', '$reference','$location', '$source')";
echo $sql;
if (!mysql_query($sql))
{
die('Error: ' . mysql_error());
}
}
?>[/php]
TIA
Colin