Inserting data in tables

Anon

I am afraid this is a beginners question, but i hope you give a little help with this.
I want to insert values in a table trough ODBC, here is the code:
$result = odbc_exec($db,"INSERT INTO TABLE (COL1, COL2, COL3, COL4, COL5, COL6) VALUES ($col1, $col2, $col3, $col4, $col5, $col6)");

well, after the sentence $result is not zero, it means that it was well interpreted,
but values were not inserted into table, why?, what should i do?, please help me...
Otto

Anon

Are you checking to see if there are any errors? I'd check the manual for something like an odbc_error() function or something and echo it out after you do your insert.

Anon

odbc_exec($db,"INSERT INTO TABLE (COL1, COL2, COL3, COL4, COL5, COL6) VALUES ($col1, $col2, $col3, $col4, $col5, $col6)");

Should actually put the text exactly as you have it into the database. If you want it to take the value of those variables it is my understanding that you need to single quote like VALUES('$col1', '$col2'...

Also... the return code for odbc_exec is result identifier, so I don't think it should be 0 so everything is good there.

-Steven

Anon

$result = odbc_exec($db,"INSERT INTO TABLE (COL1, COL2, COL3, COL4, COL5, COL6) VALUES ($col1, $col2, $col3, $col4, $col5, $col6)"); NO!!!!

$result = odbc_exec($db,"INSERT INTO TABLE (COL1, COL2, COL3, COL4, COL5, COL6) VALUES ('$col1', '$col2', '$col3', '$col4', '$col5', '$col6')"); YES!!!

Bye

Anon

Thanks, but it did not work, i am using access 2k, so i try the SQL sentence in access and it worked fine, not so in php (with and without ') , i dont know what is wrong, as i said i have tryed what you told me and it didn't work. Maybe odbc_exec is not the proper function, in java for example, you have one method for queries one for updates, does php does everithing trough odbc_exec and odbc_go... i dont know.
Pls Help
Otto

Anon

Thanks, but it did not work, any other idea?
every seems to be alright, just that the table is not updated.
Thanks.
Otto

Anon

There is not such odbc_error function Tim, and as i said everithing is fine, just that nothing happens with the table....
pls more ideas
Otto