A solution depends rather on a few important factors:

  1. Are you already using session management?
  2. Will there be more than one "session" active at a time?
  3. Can you add a unique uneditable record ID to each editable table?
  4. Can you depend on JScript being enabled for the client?

If you are using session management then caching the last query then diffing against that to drive the database update seems ok, but may become interesting if multiple access is possible.

If you have unique record IDs you can put those in hidden fields on the web page so you can easily match up records.

If you have JScript available you can use it to post before and after versions of the edited records.

You could put all the original data into hidden fields that get posted back along with the edited fields.

There are many options and trade-offs of different sorts with each one.

True laziness is hard work

In reply to Re: MySQL and Perl CGI by GrandFather
in thread MySQL and Perl CGI by PyrexKidd

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.