I want to take one row of data, compare it with another row of data by using certain mathematcial equations, and return that data to some place. How would I go about doing that?

Well, given that amount of information about the task, along with the amount of sample input data, intended output data and attempted code you've given us, I think the way you'd go about it is: 

 -  select one row of data somehow
 -  select another row of data (either in the same way, or differently
+)
 -  do some arithmetic on the two pieces of data and compare the resul
+ts
 -  Insert or otherwise store some suitable result data somewhere

[download]
Perhaps that wasn't very helpful, but it's the best I could do with what I know.

How about you try something out, and if it works, great! If it doesn't, show us the code you tried, what data went into it, what it produced, and how that differed from what you wanted. (Or, if all you get is error messages, show the code and the error messages.)

In reply to Re: DBI for noobs by graff
in thread DBI for noobs by jdlev

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.