Posted by gagal on 06/24/07 21:46

Sorry, I didn't add it in original file. After adding it, i got:

You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '(firstName, lastName, dob, category, address1, address2, city,
state, zipcode, t' at line 2



function addPerson ($connect)
{
$firstName = $_POST['firstName'];
$lastName = $_POST['lastName'];
if( $_POST{'dobMonth'} and $_POST{'dobDay'})
$dob = ($_POST{'dobMonth'}.'/'.$_POST{'dobDay'}.'/'.
$_POST{'dobYear'});
else
$dob = ' ';
$category = $_POST['category'];
$address1 = $_POST['address1'];
$address2 = $_POST['address2'];
$city = $_POST['city'];
$state = $_POST['state'];
$zipcode = $_POST['zipcode'];
$telephone = $_POST['telephone'];
$cellphone = $_POST['cellphone'];
$email1 = $_POST['email1'];
$email2 = $_POST['email2'];
$aimid = $_POST['aimid'];
$url = $_POST['url'];
$notes = $_POST['notes'];


$sql = "INSERT INTO $db_table4
(firstName, lastName, dob, category, address1, address2, city,
state, zipcode, telephone, cellphone, email1, email2, aimid, url,
notes)
VALUES
('$firstName', '$lastName', '$dob', '$category', '$address1',
'$address2', '$city', '$state', '$zipcode', '$telephone',
'$cellphone', '$email1', '$email2', '$aimid', '$url', '$notes')";

mysql_query ($sql) or die(mysql_error());

echo "$db_name";
echo "added";
}


<?PHP include("includes/connect.txt");?>
<?PHP include("ab_functions.php");?>
<?PHP
if(isset($_POST['do_addperson']))
{
addPerson ($connect);
}
?>

[Back to original message]