close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

suggestion for a better way of doing a multiple insert

Thread began 9/24/2011 9:28 am by info97301 | Last modified 10/03/2011 9:32 am by info97301 | 1494 views | 8 replies


Hi Craig

Thanks for the interest.

It's only on localhost at the moment, however, I will try to explain;

Currently, I have a page to 'add officers' - there are 20 'posts', such as treasurer, secretary, xxx cttee chairman, yyy cttee chairman, etc.

On the existing page, I select the appropriate year, post and post-holder - from about 2,000 members. As the list of members is a drop-down menu, as you start to type the surname the menu jumps to the first corresponding match, which makes trawling through 2000 members much easier! When the post is added, the form returns the user to the same page to add the next officer.

I would like to have a multiple insert page, where you select the appropriate year at the top of the form and the 20 available posts are displayed in the first column - with a corresponding drop-down list for each potential post holder.

This is where I run into trouble - the multiple insert form appears to be created properly, with all the repeat selections in place - but when I try to test the page, the computer gives up, presumably because it needs to populate drop-down lists for 20 posts with 2000 members.

I wondered if there was a way that I could maybe have the recordset and start typing the surname of the post-holder without the need for a repeated drop-down menu, as this is what appears to be causing the problem. An array of some sort? Don't know!!

I'm using a MySQL database. the appropriate tables are:

years (YrID int, YearName nvarchar e.g. 2010-2011)
posts (PostID int, postname nvarchar)
members (memID int, surname, firstname etc)
postholders (phID int, phYrID int, phPostID int, phMemID int)

Any ideas much appreciated - whilst the single entry method works, a multiple entry page would simplify things for users.



Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...