MySQL, Multiple tables, and Multipage form using sessions

From: 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

« previous php.db (#36776) next »