SQL query

Anon

I have setup database driven pHp/mySQL website but I want to insert value into more than one table in mySQL table at submit button. How am I suppose to do it other than PL/SQL stored procedure.

Thank you for your help..

Anon

An individual sql query can only update one table at a time,
but your script can issue as many queries in sequence as
you need to update all the tables required.

Anon

Thanks for the reply Kirk.

As such I have 2 webform accessing the same database table but suppose if by some mean 2 people enter the information around the same time from differnet forms then I hope it doesn't create the same id or other information? It is posibile for the deadlock situation when 2 sepate SQL commands exexute through the script and at the same time someone else insert/update the information at the same time.

Anon

That's really up to the database, but in general
if the db has a serial-number or auto incrementing
capability you should use it (and live with the
portability problems--i.e. every db has a different
way of doing it because it's not part of the SQL
standard.) Doing this will guarantee there are
no race or deadlock conditions, which pretty
hard to solve if you're creating the ID numbers
on the client side.

Anon

hello kirk,

As such I tried executing number of queries.
but it seems there is an error.

actually I have 2 table T1 and T2 in the database D1. I want to insert into both tables using submit through single php script using mysql_query="INSERT id auto_increment PRIMARY KEY, companyid, name, address" in table T1 and
mysql_query="Insert companyid PRIMARY KEY, companyname, companyaddress" in table T2.

The pt. here is I cannot insert information using indivisual separate SQL command in php since both tables are related to each other and normalized. The information I insert into first table should be required in the 2nd table which is in relationship to the particular information of the cliets inserted in the table T1. Other than writing in PL/SQL which I don't have idea whether mySQL supports what is the other way through php script command line?
I would be very thankful if you can post sample script or related document example link or logical answer to it.

Thank you

Anon

The pt. here is I cannot insert information using indivisual
separateSQL command in php since both tables are related to each other

You're in big trouble if they are, but nothing you show above
indicates that this is actually the case. I see the T2's primary key
'companyid' being used in T1, but nothing from T1 being used in
T2. Actually, your example is a little hard to follow because
the queries you wrote don't even look like valid sql. Perhaps
you could post the actual table and index definitions for
T1 and T2 together with the actual PHP code for the updates?

Anon

Thanks for the help Kirk,

I've solved the problem at present by separated my db tables without relating to each other since it is not a very big one, as for the command I'm still writing the codes for it.