[Resolved] INSERT INTO problem with MSSQL

[kenhess]

I am trying to insert data into a table in mssql and am using an autoincremented ID field for the records as they go in.

can someone give me the proper PHP for doing this insert?

I can do it with SQL Query Analyzer, but in PHP there seems to be a hitch.

INSERT INTO TABLE BLAH (ID, FNAME, LNAME) VALUES ( 'Bob', 'Jones')

will work in SQL Query Analyzer, where you just leave a space at the place where you would have an ID number, but in PHP, I have tried everything I know to try...in MySQL I would have done:

INSERT INTO TABLE BLAH (ID, FNAME, LNAME) VALUES (\" \", \"Bob\", \"Jones\");

but this doesn't insert the data into mssql, but does in mysql.

[maxpup979]

try doing the insert without specifying the id...ie: insert into table (name,whatver)values('yadda','yadda')--the autoincrement will take place automagically

[pete_bisby]

Your query won't work because the number of attributes on the left hand side of the query do not match the number values being input on the right hand side.

If the ID attribute is auto-increment, you shouldn't need to include it in your query - the database should automatically enter the correct value in for you. E.g.

INSERT INTO BLAH (FNAME, LNAME) VALUES ( 'Bob', 'Jones')