MYSQL Insert String Problem

[patrick78]

I have an html form that passes values to a PHP script via POST.

The highlighted insert statement values don't display, instead only quotations show up, and so the values don't get added to the table properly:

insert into user values ( NULL, 'Patricio' , '167' , '170' , '69' , '2011/03/12' , '56' , '' , '' , '' , ")
Now when I echo the variables individually, they display fine, but they aren't showing up in the query string which i don't understand. These are select values from the form, 1's and 0's for true and false.

The query:
$query = "insert into user values ( NULL, '$name' , '$weight' , '$bpupper' , '$bplower' , '$date' , '$height' , '$weightchoice' , '$bpchoice' , '$consumedchoice' , '$burnedchoice' )";

Note: I have tried with periods and double quotes surrounding the variables and not. Example:
'".$bpchoice."'.

Any suggestions greatly appreciated..

[dalecosp]

Do you have code to show? How are you echoing the variables to make sure they have values? How do you know the database is empty?

[Judgey92]

Sounds like the variables are not being set properly, please check to see that the variables are being set with a value.