Forums

This topic is locked

Inserting form data in two tables

Posted 13 Dec 2008 14:11:37
1
has voted
13 Dec 2008 14:11:37 Sikander Khan Muhammed posted:
Recently i edited my new user page in dreamweaver cs4 i created two fielsets 1 -> Account info: 2 -> Personal Info:

the information of account info will be saved in one table where the personal info in other

how can we use the insert record server behavior to insert this data in two tables




Sikander

Replies

Replied 13 Dec 2008 14:48:11
13 Dec 2008 14:48:11 Alan C replied:
do a JOIN on the two tables then you will be able to access all the columns
Replied 13 Dec 2008 15:10:55
13 Dec 2008 15:10:55 Sikander Khan Muhammed replied:
can you clearly explain, how to join two tables

Sikander
Replied 15 Dec 2008 10:36:15
15 Dec 2008 10:36:15 Alan C replied:
en.wikipedia.org/wiki/Join_(SQL)


if you run a search for table joins you will come up with lots of different tutorials some easy to understand others harder.

Make a couple of simple tables and give it a go <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Reply to this topic