when inserting a new record, how would you pull the identity column, assuming it's auto-incremented?
in SQLServer 7.0 (which I'm used to) you can use
SET NOCOUNT ON;
INSERT
(fields)
VALUES
(values);
SELECT @@Identity as requiredID;
which returns you the newly created ID field
How would i go about this using mySQL 3.23 for Windows NT with PHP? I can't find anything in the docs (but i could be looking in the wrong place)
cheers guys
j
in SQLServer 7.0 (which I'm used to) you can use
SET NOCOUNT ON;
INSERT
(fields)
VALUES
(values);
SELECT @@Identity as requiredID;
which returns you the newly created ID field
How would i go about this using mySQL 3.23 for Windows NT with PHP? I can't find anything in the docs (but i could be looking in the wrong place)
cheers guys
j