I can get the previous insert auto-increment id via mysql_insert_id(). it
will solve my problem. but if you know a soloution that will work in one
query please share it with me/everyone!


--
JJ Harrison
[EMAIL PROTECTED]

"Noodle Snacks" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have table A with an auto increment coloumn called tid. during the same
> query I need to get that value and stick it in a related record in
anouther
> table.
>
> I have two doubts.
>
> A: What is the way to do a multitable insert? guess is: INSERT INTO
> table(fields) VALUES (fields), table1(fields) VALUES (fields) etc... is it
> even possible in one query?
>
> B: how can I get the auto increment value from one into the record on the
> other table?
>
>
> --
> JJ Harrison
> [EMAIL PROTECTED]
>
>
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to