PHP 4.0 Bug #10484 Updated: Problem with insert in ODBC

ID: 10484 User Update by: Domlane@hotmail.com Old-Status: Feedback Status: Open Bug Type: ODBC related Description: Problem with insert in ODBC Yes it is correct! As there only are two fields in my table and that I try to fill them all, I can work it this way I could have use "INSERT INTO test (field1, field2) VALUES ('a', 'b')" "INSERT INTO test VALUES ('a', 'b')" work the same way Previous Comments: --------------------------------------------------------------------------- [2001-04-25 10:08:26] kalowsky@php.net unless I'm missing something your INSERT statement is not correct. --------------------------------------------------------------------------- [2001-04-25 00:27:18] Domlane@hotmail.com $BD = odbc_connect ('BdTest', SQL_CUR_USE_DRIVER); $SQL = "insert into test values ('a', 'b')"; $TabUser = odbc_exec($BD, $SQL); this don't work...nothing had been added in the table test $BD = odbc_connect ('BdTest '', SQL_CUR_USE_DRIVER); $SQL = "select * from Utilisateur where Nom_utilisateur = '$Nom' and Mot_de_passe = '$Pass'"; $TabUser = odbc_exec($BD, $SQL); This work fine! How should i use "insert" statement in order to make it works?? --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=10484