MySQL, Multiple tables, and Multipage form using sessions
| From: | Stuart Felenstein | Date: | Wed, 13 Oct 2004 20:41:46 +0000 |
| Subject: | MySQL, Multiple tables, and Multipage form using sessions | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36776@lists.php.net to get a copy of this message | ||
Can anyone, someone please point me in the right
direction.
I have a multi page form, so at the last page I want
to insert all data into database. Basically I'm trying
to go from 0 - 90 , meaning my skills are less the
basic. And this seems like a big task.
Couple of other things.
1-There would need to be rollback. One insert fails,
they all get rolled back.
2-The first table that get inserted has a "recordID",
from an auto inc int field. That recordID has to be
put into all of the other child tables.
3-There are two multi select boxes. The challenge
with them is they need to be looped in the insert to
their respecitive tables.
i.e.
Choice of colors - 5 (multi select)
+----------+----------+
| RecordID | Color |
+----------+----------+
| 295 Blue |
| 295 Red |
| 295 Green |
| 295 Oragne |
-----------------------
Are there any tutorials , good books that go into this
type of depth ? Is it really simple and Im just scared
? :)
I'm open to listening ,
Thank you ,
Stuart