[SOLVED]  adding data to multiple tables

This topic is locked

[SOLVED] adding data to multiple tables	7/22/2005 1:21:30 PM
PHPRunner General questions
author I'm trying to create a small library database with MySQL and PHP. I've created a lot of code with PHPRunner, and I like it, but I have not been able to intuitively determine how to get data in to multiple tables via just one page. For example, I have a title table, an author table, and a publisher table. How would I go about creating a single entry form that lets me input that information and have it stored in the seperate tables?


	Sergey Kornilov admin 7/25/2005
	Jerry, you cannot add data into three tables simultaneously. Here is how it's usually being done. You build code for all three tables. Author and Publisher will be lookup tables. You add new Authors and Publisher as they appear. When you edit Title table you use Lookup wizard dropdown box to fill author and publisher fields. You do not need to add new Author and Publisher everytime you ading title.