Bug #10484 Updated: Problem with insert in ODBC

ID: 10484 Updated by: kalowsky Reported By: Domlane@hotmail.com Old-Status: Open Status: Feedback Bug Type: ODBC related PHP Version: 4.0.4pl1 Assigned To: Comments: you're correct insert statement is fine, needed more wake up time on that. your odbc_connect is wrong. you need to provide 3 or 4 parameters, not just two. as per the description found at: http://www.php.net/manual/en/function.odbc-connect.php Previous Comments: --------------------------------------------------------------------------- [2001-04-25 10:17:50] Domlane@hotmail.com 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 --------------------------------------------------------------------------- [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?? --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10484&edit=2