Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New Coder
    Join Date
    Apr 2007
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    edit and delete the table

    can anybody help me am new to php/mysql

    i have two tables in my database(name knownerror)

    table1
    username userid
    php 1
    c 2
    c++ 3

    table2
    userid problemid error solution
    1 1 no clear
    2 2 yes notclear
    3 1 yes notclear

    like this.i have webpage displays like this
    php
    c
    c++

    if i click php, the database display in the (next) result page is


    problemid error solution
    1 no clear
    1 yes notclear

    upto this i will clear now how can i edit and delete this table . the edit and delete icon is in result page itself like below

    problemid error solution action
    1 no clear edit delete
    1 yes notclear edit delete

    can anybody help me plz

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    what application language are you going to use to do this? PHP, PERL? This thread belongs in one of those forums. I can move it for you but want to choose the right forum.

  • #3
    New Coder
    Join Date
    Apr 2007
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i have two tables in my database(name knownerror)

    table1
    username userid
    php 1
    c 2
    c++ 3

    table2
    userid problemid error solution
    1 1 no clear
    2 2 yes notclear
    3 1 yes notclear

    like this.i have webpage displays like this
    php
    c
    c++

    if i click php, the database display in the (next) result page is


    problemid error solution (action)
    1 no clear (edit and delete icons)
    1 yes notclear (edit and delete icons)


    here i want the new column (action) was also been display with edit and delete icons.if click those icons i want to get the (edit/delete) results.
    i think now u can understand my problem

  • #4
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    You can't do this in mysql, you would have to add buttons in perl or php or coldfusion or whatever application you use as the front end to mysql.

    so what are you using? your question is not mysql related. your question is about the code that you would need to do this in php or perl or whatever.

    If you tell me what language/application you are using then I will move the thread.

  • #5
    New Coder
    Join Date
    Apr 2007
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thank you i got the answer.

  • #6
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    then please post the answer you got. It is not good etiquette to come to a discussion forum looking for help and then not post the answer, whether you got it here or elsewhere.

    your input would help other users who are looking for a solution to a similar problem as yours.


  •  

    Posting Permissions

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