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

New problem now
I made change and got:

Warning: Missing argument 1 for addperson() in /home/smith/public_html/
personal/ab_functions.php on line 20
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

I'm sure insert code works because if I just run it from page with
form it is ok.

This is the new add function

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";
}

[Back to original message]