Input to 2 tables

Anon

If I want to write input
to 2 different tables
from a simple form
where I only use LOGIN & TEXT
(I actuarlly use 3 tables)
Name of tables:
T1: Userinfo
(in this table we will find userNR, First/Last Name, Login & Password)
T2: News
(this table contains NewsNR, userNR,
Updatedate, CreateDate)
T3: Newstext
(this table contains RowNR, NewsNR, Text)

//Notice that some columns are used in
2 tables. That is userNR which shall be readen from Userinfo to News
& NewsNR that shalt be readen from
News to Newstext

I only want the form to input
the text & user.
Now I want it to..

Damned I don´t even understand myself
so how shall you understand???

IF someone understands my problem
please contact me.. Cuz I don´t understand
anything..

BTW, Writing into 2 tables.
Then shall I use 2 sybase_query´s
one for each table?

PS: I use Sybase.

Best Regards.
/Chess

Anon

I believe I use PHP3,
that means I cannot use Sessions????

hmm....

(I need a break)

/Chess

Anon

this is concurrent access to more than 1 table, and in this case you need foreign keys to be defined.

e.g. In news userNR is foreign key from userinfo

and

newsNR is foreign key in NewsText from news

anyway, its a bit of a tricky thing to update more than 1 table, with same ID's in all of them. cos you cant simply call more SQL query's and do INSERT in the other tables with the newly added record in primary table. which e.g. has teh primary key as auto_increment. so how do you retrieve the ID which you just added? you can say, why not get last record in the table, as you just added it. ut what if there is some other user clicked the submit button at the same instance as you did? then your fetched last record might be someone else's

i am going to post a new topic on concurrent accesses, so we can look in to there.

cheers.