At 11:42 -0500 3/20/02, Andrew Hazen wrote:
>I am loading table A from values in table B with an insert . . . select
>I also need to populate a x-ref table with the new insert ids from the
>insert . . . select.
>I know in Oracle I would put a trigger in to do the x-ref insert after
>each row of the insert. . .select is processed.
>Is there anyway to do this in mysql/php?
Yes, you do it yourself. :-)
You'll probably find the PHP mysql_insert_id() function helpful in
>Jatech Solutions Inc.
>160 Bartley Drive