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!
"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
> 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