[code=php]
$sql = “INSERT INTO tell (
name,
1,2,3,4,5,6,7,8,9,
comfort,
function,
health,
appearance,
precision,
peace_of_mind,
durability,
other,
other_blank,
money,
time,
personal_effort,
physical_discomfort,
fear_and_anxiety,
other2,
other_blank2
) values (
‘”.$_POST[‘name’].”‘,
‘”.$_POST[‘1’].”‘,'”.$_POST[‘2’].”‘,'”.$_POST[‘3’].”‘,'”.$_POST[‘4’].”‘,'”.$_POST[‘5’].”‘,'”.$_POST[‘6’].”‘,'”.$_POST[‘7’].”‘,'”.$_POST[‘8’].”‘,'”.$_POST[‘9’].”‘,
‘”.$_POST[‘comfort’].”‘,
‘”.$_POST[‘function’].”‘,
‘”.$_POST[‘health’].”‘,
‘”.$_POST[‘appearance’].”‘,
‘”.$_POST[‘precision’].”‘,
‘”.$_POST[‘peace_of_mind’].”‘,
‘”.$_POST[‘durability’].”‘,
‘”.$_POST[‘other’].”‘,
‘”.$_POST[‘other_blank’].”‘,
‘”.$_POST[‘money’].”‘,
‘”.$_POST[‘time’].”‘,
‘”.$_POST[‘personal_effort’].”‘,
‘”.$_POST[‘physical_discomfort’].”‘,
‘”.$_POST[‘fear_and_anxiety’].”‘,
‘”.$_POST[‘other2’].”‘,
‘”.$_POST[‘other_blank2’].”‘,
)”;
I keep getting the following error when I submit my form:
You have an error in your SQL syntax near ‘1,2,3,4,5,6,7,8,9, comfort, function, health, appearance, ‘ at line 3
any ideas?