form data --> mysql database

[Anon]

I'm sure this is a simple problem, but its driving me nuts. I'm trying to insert data from a submitted form (POST) into a mysql database. However, the following snippet of code gives me a php parse error at the first $_POST variable. What am I doing wrong??

$voidquery = "INSERT INTO survey_void
(survey_id, b-534843-b, r-4450010033-b, etc etc) VALUES ('$insert_id',
'$POST[534843-void]', '$POST[4450010033-void]', etc etc)";

All the submitted values are single digit numbers. Printing out the $_POST array shows that all the values are there. Thanks for any help in advance.

[Anon]

try:
$voidquery = 'INSERT INTO survey_void
(`survey_id`, `b-534843-b`, `r-4450010033-b`, etc etc) VALUES (\'' . $insert_id . '\',
\'' . $POST['534843-void'] . '\', \'' . $POST['4450010033-void'] . '\', etc etc)';

[Anon]

You shouldn't need to escape all of the single quotes ' plus it makes it a nightmare to read.

Just after you have set $voidquery print it out to the browser

Print "The query is $voidquery";

and see what you get.

You also said they were numbers, try not putting single quotes around them.