"Column count doesn't match value count at row 1"
Posted: Mon Jul 17, 2006 12:14 pm
Can anyone see anything wrong with this insert statement there are 19 coloms and 19 values being inserted but I am getting message saying "Column count doesn't match value count at row 1"
Please help
Code: Select all
PRINT $sql = "INSERT INTO feedbackcontacts
(
salutation, name, surname, organisation, email,address,address1,
telephonefax, mobile, mscints, mscactive,otheractivities,
gradjobs, ugproj, pdev, bcsmem, bcspds,
teach, acconsult, person_id
)
VALUES
(
'$salutation','$name','$surname','$organisation','$email','$address',
'$address1', '$telephonefax', '$mobile','$mscints','$mscactive','$otheractivities'
'$gradjobs', '$ugproj', '$pdev','$bcsmem','$bcspds','$teach',
'$acconsult','$person_id'
)";