Jump to content

updating records, need submit help


Recommended Posts

I am trying to figure out how to update multiple records (on an online administration page) from a repeating region. Here is an example that would be perfect, but I can't figure out how to submit the changes:

 

http://www.stickymultimedia.com/maxs/beerl...inistration.php

Description: The DB is 1 table of beer names with other fields for descriptions (the other fields aren't really used here). The color columns relate to 4 different pubs (bars). I want the administrator to simply be able to check (checkbox) which pubs the beer is currently available at. Currently it seems to be set up correctly. The checkboxes come up filled if the current feild is true. (-1) or unchecked if false (0).

I just need to know how to submit all the data changes. Each of the checkboxes is a seperate little form., dynamicly repeated. Maybe that is a problem? Maybe even if I had to have a submit button for each record on that page or something, but I hope not. I'm hoping I can make all the changes with the checkboxes, then hit a submit button.

 

 

Using the master/detail behavior, I am able to set up a master page that lists all the beers. I can make each beer name a link to the detail page. I know how to modify the detail page to be an "update" page with a submit button, using the primary key from the master page. I have a book that shows me how to set this up but it seems too time consuming to have link to an update (detail) page in this way.

 

 

 

I do not know PHP or mySQL (yet). I am simply using a book and Dreamweaver MX 2004. I seem to be close to what I am trying to do. :) ??

 

By the way, here is a link to a master/detail page that I was testing. It doesn't do anything though:

http://www.stickymultimedia.com/maxs/beerlist_master.php

 

Thanks for any help!

Tony

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.