www.webdeveloper.com
Results 1 to 3 of 3

Thread: updating records

  1. #1
    Join Date
    Nov 2006
    Posts
    22

    updating records

    Hi,

    I need some help trying to update records in my database via the web.
    I'm coding in notepad, and I would like to the admin of the website to be able to click upon the record they want to update and then be taken to a new page that lets them edit all of the fields within the database for that record.

    All the examples I seem to find are only to update a age to a set amount, if anyone has a link to a tutorial that would help or can give me any advice that would be great.

    thank you

  2. #2
    Join Date
    May 2006
    Posts
    2
    you initially need to generate a page with all the records (displaying probably just the primary key or identifying value) Each could be a link passing the unique identifying through on the query string to the update page

    Then the "Update Page" would involve having a form with a bunch of text or combo boxes that are prefilled with corresponding values from the particular record selected

    Then do an UPDATE query that inserts all the values back into the database (overwriting the ones already in there for that particular record)

  3. #3
    Join Date
    Nov 2006
    Posts
    22
    Thanks for your help.

    I've got it working now with a drop down menu.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles