At 10:40 AM 8/8/2003, fstorr wrote: >Hi all > >I need to do a SQL insert statement into three tables. However, the >second table contains a column which is a foreign key to the first >table's auto incrementing index. How do I insert this value into the >second table (I'm using PHP+MySQL) when I don't actually know what it >is? Insert into first table and then get the ID added by the DB Engine for use with the other inserts. SELECT LAST_INSERT_ID() --- Anthony Baratta President Keyboard Jockeys "Conformity is the refuge of the unimaginative."