AYYASH — Tue, 27 Apr 2004 06:27:32 +0000

Yes Suzanne, you are right. It looks so complicated to me to understand.
Any way, thanks again for your help. You are very remarkable in this forum.

Suzanne — Sun, 25 Apr 2004 16:07:47 +0000

I'm glad you got it sorted out! Dreamweaver has condensed a lot of the code, which is fine, but makes it difficult for human types to read through it easily unless they are very fluent.

AYYASH — Sun, 25 Apr 2004 10:32:06 +0000

Thank you s0da and Suzanne for your help.

I've finally solved the problem.

s0da — Sun, 25 Apr 2004 08:04:36 +0000

you grab the last ID inserted; then you insert or update it intot he database

1. insert ...
2. grab insert id ...
3. insert/update using insert id ...

AYYASH — Sun, 25 Apr 2004 08:01:11 +0000

Well,

I have master table called "initiation". The index field called "indexNo" and it's auto incremented. I want the value of this filed to be inserted automatically to the other index fields for the other four tables (estimate.estimateID, printreq.preqID, printquot.quotID, request.reqID) every time I insert a new record. Later I want to be able to make relations between these tables by using the value that has been inserted.

In MySQL 5, they solve this problem by adding procedures and triggers. But we have to wait until it's officially released.
In the mean while, I have to do it using PHP. I know how to write a good SQL syntax but I can't integrate it with the PHP code because I'm not good at it. As you can see in the code I posted ubove, this is difficult for me to understand.

Thanks in advance

Suzanne — Sun, 25 Apr 2004 07:17:56 +0000

What are your other tables like? I assume that that ID is in them -- you just INSERT your data into those tables with that ID set to the value you get... ?

Can you provide more explanation of the other tables?

So... INSERT INTO othertable SET id = '$ID1', field = '$value'

Does that make sense?

AYYASH — Sun, 25 Apr 2004 06:57:52 +0000

Thanks,

But how can I use "$Id1" to insert its value into other tables?

s0da — Sun, 25 Apr 2004 06:51:52 +0000

$Id1 = mysql_insert_id(); # this will get the last AUTOINCREMENTed `ID` inserted into the database