MySQL, Multiple tables, and Multipage form using sessions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux