Re: Inserting Data in Multiple Tables.. again
| From: | Justin Patrin | Date: | Tue, 16 Mar 2004 17:07:48 +0000 |
| Subject: | Re: Inserting Data in Multiple Tables.. again | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33469@lists.php.net to get a copy of this message | ||
Craig Hoffman wrote:
Here is the problem I am experiencing: I have a form that collects data and I would like it to send it to three tables in a MySQL DB. One table is called TRAININGLOG , other is called CORE and the third is USERS. The USER table is the main table that contains the primary key. My question is, what is the correct way for handling something like this? Do I need to write three separate queries (INSERT) statements? I am using MySQL 4.0.17 if that helps? Thanks in advance, Craig __________________________________ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: choffman@eclimb.net w: www.eclimb.net _________________________________You need three seperate queries. -- paperCrane <Justin Patrin>