Inserting Data in Multiple Tables.. again
| From: | Craig Hoffman | Date: | Fri, 12 Mar 2004 22:37:30 +0000 |
| Subject: | Inserting Data in Multiple Tables.. again | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-33433@lists.php.net to get a copy of this message | ||
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
_________________________________