You've changed your OP without indicating what's been changed. Please don't do this. "How do I change/delete my post?" explains how to update a node (and why you should do it this way).

You've added code to your OP which differs from the code you posted in reply to my original response. This is not helpful.

Strings in double-quotes are interpolated. When perl sees "... @whatever ...". it assumes @whatever is an array. You can use single-quotes to stop interpolation or escape the '@' character (as you did in "SET \@num := 0, \@id := -1;").

-- Ken

In reply to Re: DBD and a MySQL query with a SET @num line by kcott
in thread DBD and a MySQL query with a SET @num line by edieguez

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.