thanks , but it seems not what I want..
thanks for reply...
but what I want is insert record into "one" table and it have the auto_increment field `id` and a field `Xid` which automaticallly insert the value of `id` ...
the answer you tell me is that insert a record into "A" table then store the value in session variable .... then insert record into "B" table by using the session variable....
even though using the session variable to insert into "A" table can do the thing I want ...
but is there any idea to insert the record just using "one" insert server behavior ... NOT "TWO" insert server behavior???