post variables and sql

[Anon]

I don't know whether this is answered in the manual anywhere because I haven't been able to find it. Forgive me if it has.

I am trying to add a record to a ODBC database by posting the variables from a form to a new page that adds the record and displays the updated table.

The error occurs in the following line of code:

$sql = "INSERT INTO MyTable(Field1,Field2,Field3) VALUES($post1, $post2, $post3)";

The parser doesn't like me using the variables in the sql statement as I think the variable's contents are not being substituted where the $post appears in the query.

Is there a better way to achive my task than the way I am doing it? Is there a syntax problem with the variables in the SQL statement?

Thanks in advance.

[firake]

Try adding "'" (single quote) on the variables (e.g $post1 -> '$post1')

[Anon]

Mistake in your sql string is this you need to put double quotes around your varialbes:

$sql="insert into $tablename values (\"$post1\", \"$post2\", \"$post3\")";

Give it a shot,

Di

[Anon]

only use quotes when the field value is text

$query="INSERT INTO tablename (textfield,integerfield) VALUES ('$query1',$query2);"