When I have multiple tables in a database linked by primary/foreign keys, how do I update or insert (from a form) to the corresponding rows in more than one db table at a time?
Unless your running (MySQL) version 4 or higher, you can't. Multiple queries is the way to go. Update/insert on the outer tables first, and grab the key for use in the inner table with mysql_insert_id().
Thanks Shrike mySQL is only 3.23 so I'll look into mysql_insert_id() Cheers
