Your question is not at all clear. I don't know if this is an English as a second language problem or not? If so, tell us about that issue. Many Monks have been responding to you, but either you don't understand what they are saying or you are just ignoring their advice.

Your code is nowhere near close to working. It appears that you are trying to look up order numbers in a DB and then get a JSON doc related to that order? It is unclear what you do after that. next if ($status ne 'NOT-GOOD') { looks like confusing nonsense.  my $ordernumber = $query->fetchrow_array() is wrong. Look at fetchrow_array for the specification of what that method does. Some basic debugging is expected when you post code. print "$ordernumber\n"; before my $url = "link.com/$ordernumber"; would have shown you something important.

In reply to Re^3: continuously query by Marshall
in thread continuously query 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.