Easiest way to modify SQL data for a table?

Discussion in 'MySQL' started by j0563, Oct 27, 2010.

  1. #1
    I have a table which lists all my employees and some data about each. I have the data displayed in the browser in a simple HTML table.

    I would like to have an "edit" and "delete" button next to each employee. Clicking the "edit" button would turn each field shown into a textbox whose contents can be modified, saved, then updated in the database.

    Clicking the "delete" button would obviously delete the row for that employee, which is easy enough to do.

    I REALLY need some help trying to get a simple way for the "edit" button to work... could anyone help me out?
     
    j0563, Oct 27, 2010 IP
  2. Layoutzzz

    Layoutzzz Greenhorn

    Messages:
    78
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    18
    #2
    Hi j0563
    You should add a new page for edit your data from database.
    You can do it yourself if you have knowledge in programming.
     
    Layoutzzz, Oct 27, 2010 IP
  3. seotraining

    seotraining Active Member

    Messages:
    511
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    70
    #3
    For that you should hve a knowledge of php script. You can do this using php page fetch the data in textbox and forms and then modify it
     
    seotraining, Oct 27, 2010 IP
  4. viriya123

    viriya123 Peon

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    The best suitable tool for this job is Jquery
     
    viriya123, Oct 28, 2010 IP