"you can't blame IBM for using fetchrow"

Yes, you most certainly can. IBM has a track record of mucking with things that didn't need mucking with.

The authoritative source for the use of a Perl distribution is the author's documentation, not a completely unaffiliated company.

I have had my software modified by a company in the past without any mention of the change, while leaving my contact information in the troubleshooting section. It was infuriating when I received a large number of email complaints that "your software doesn't work!".

Regardless of what it is, you're doing something wrong as your code isn't doing what you want, so leave IBM out of it, and refer to the proper documentation. That's your best bet to get back on track.

The authoritative methods you're looking for are:

fetchrow_arrayref() # fetch a single row, put it into an array referen
+ce
fetchrow_hashref()  # fetch a single row, put it into a hash reference

fetchall_arrayref() # fetch all rows into an aref of arefs
fetchall_hashref()  # fetch all rows into an href of hrefs

[download]

In reply to Re^5: checking mysql rows continuously by stevieb
in thread checking mysql rows continuously by bigup401

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.