Insert Script

[Anqui3tas]

I cant seem to figure out/remember how to get nUserNo into other tables in a similar script to this:


insert into account.dbo.tUser (sUserID, sUserPW, sUserName, bIsBlock, bIsDelete, nAuthID, sUserIP)
Values ('email', 'password', 'email', '0', '0', '9', '127.0.0.1')


insert into account.dbo.tMinorsPlaytime (nUserNo, bIsAdult, nPlaytime) values (?, '1', '1')


Insert into account.dbo.tUserOption (nUserNo, sEmail, sPhoneNo, bistext, nZipNo, sAddress, bIsMail, sAge, sIsReferred,sFirstName, sLastName)
Values (?, 'Email', '1-555-555-5555', '1', '95006', '123 Street Name', '0', '24', '0', 'First', 'Last')

as i would like this to be all one form.

[MentaL]

[fiestanerd69]

You can insert a row into the tMinorsPlaytime with the following query:

INSERT INTO Account.dbo.tMinorsPlaytime (nUserNo, bIsAdult, nPlayTime, dLogoutDate) VALUES (1, 1, 1000, GETDATE())

As for getting the nUserNo, you need to get it when you insert it or use a select query to get it.

[Anqui3tas]

yeah i know i can insert a userno on the last 2 tables, but id like the script to pull the nuserno from the tUser table.
so that i dont have to change the script each time. (as it will be a web form)
is there a way to "get" that (nuserno) without going in to tuser and seeing which number it creates

[LolOmgNoob]

Why not add it all to a register form? It shouldn't be that hard, i'm sure some php users that linger around these parts still maybe help you get started.

[Evildarkang]

I will be attempting to build a php document without sql injection so you'll need to add that unto yourself. However i will make it for you.

[Anqui3tas]

Why not add it all to a register form? It shouldn't be that hard, i'm sure some php users that linger around these parts still maybe help you get started.

i guess i could do that, i just wasnt ready to start on web stuff yet.

but id still like to learn how to pull info like that.

[fiestanerd69]

Closing this thread seeing as there has been no update from OP.