SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Zealot
    Join Date
    Dec 2010
    Posts
    107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to find the updated value from the mysql table

    Dear all

    I want to know the updated value.

    I am fetching the table values in a form to allow the user to modify them.

    Now I want to know which values he has modified.

    Please help me to resolve this


    Thanks
    MD.Samiuddin

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,494
    Mentioned
    161 Post(s)
    Tagged
    4 Thread(s)
    In the script that receives the form values, get the original values from the database and confront them.

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,215
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by guido2004 View Post
    ... and confront them.
    hey! you original values! what the heck are you doing there!

    i think you mean compare, not confront
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,494
    Mentioned
    161 Post(s)
    Tagged
    4 Thread(s)
    Quote Originally Posted by r937 View Post
    hey! you original values! what the heck are you doing there!

    i think you mean compare, not confront
    Yes, I knew it wasn't the correct word, but "compare" just didn't come to mind
    Let's hope the OP understood anyway.

  5. #5
    SitePoint Zealot
    Join Date
    Dec 2010
    Posts
    107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks, I will do that and check the result

  6. #6
    SitePoint Enthusiast rajeev13's Avatar
    Join Date
    Nov 2012
    Location
    New Delhi,India
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by samiuddin.adse View Post
    Dear all

    I want to know the updated value.

    I am fetching the table values in a form to allow the user to modify them.

    Now I want to know which values he has modified.

    Please help me to resolve this


    Thanks
    MD.Samiuddin
    MySql or Sql server does not keep the track of updated value in the table,although mySql can find the last inserted record if the table has an column with auto increment property .

  7. #7
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,215
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by rajeev13 View Post
    MySql or Sql server does not keep the track of updated value in the table,although mySql can find the last inserted record if the table has an column with auto increment property .
    rajeev, i don't think you understand the question

    he's asking how to know which form values the user changed
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  8. #8
    SitePoint Enthusiast rajeev13's Avatar
    Join Date
    Nov 2012
    Location
    New Delhi,India
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    rajeev, i don't think you understand the question

    he's asking how to know which form values the user changed
    ok.
    then i was just replying regarding MySql behavior as i know.although i m not expert in php and mysql.


Bookmarks

Posting Permissions

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