MS Sql / PHP / Affected rows?

Anon

Hi there, I'm currently writing an application that uses php to write to a MS Sql database, the table I'm using has a auto number in one of the field. When I post a new record this will automatically increment but how can I find out what this number is straight after posting the data?

I want a page which confirms the data has been received and a message with the reference ID... i.e. "your record has been assigned record ID 576"

any ideas? thanks.

stevenrhiggins

Will you know the value of any of the fields that will be written to the new record?

Anon

I don't think I would know any of the fields apart from maybe the ipaddress of the machine, but I wouldn't really store that.

Anon

Once the data was written you would have to (dont quote me !) do a search on the details to get the number.

so for example once the data is in the DB you would do a search like

select user_id where first_name like "xxx" and last name like "xxx" and email like "xxx".

then retreive the user ID and display it

mark wrote:

I don't think I would know any of the fields apart from maybe the ipaddress of the machine, but I wouldn't really store that.

gio2k

Have you tried a
"select @@identity" ?

-Gio-

stevenrhiggins

That only works if he knows the value of a any of the fields in the record, otherwise there is no WHERE in the query. I don't think affected_rows can be used on INSERT INTO only SELECT, DELETE and UPDATE.

Anon

well how do the likes of amazon give you an order number straight after you place the order? Any one know?