Forum Moderators: coopster

Message Too Old, No Replies

insert records with 1 submit

I need to submit several fields into several records.

         

rogerg1967

3:47 pm on Apr 3, 2007 (gmt 0)

10+ Year Member



I have a form that lists all the counties in the UK. This information is in a record taken from a table. This is then listed using a repeated region to show all of these. I need to select all or some of these and insert into separate records in mysql database. I am using dreamweaver to create my web pages and I have very limited knowledge on PHP. I think I need to create a loop but I have no idea how to do this.

Hoping you can help.

Roger

coopster

10:20 pm on Apr 3, 2007 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Hi rogerg1967, welcome to WebmasterWorld.

Are you asking how to create a loop control structure [php.net]? Or how to SELECT the data from your database table and loop through that data? You may need to show us a small example of how the data is stored and what you are looking to accomplish.

rogerg1967

11:27 pm on Apr 3, 2007 (gmt 0)

10+ Year Member



Hi,
I am looking to do a control structure i think. I have a loop already which is displaying all the countys in the table, but when i push the submit button it only enters the last county into the database. What i need it to do is to send the selected countys to the database. They can be selected from a drop down list.
I am very very new to this and i use dreamweaver to create my web pages. I can send you the code for the menu if that will help.

Thanks again

Roger