Often it can help to crunch the code and database down to just enough to show the issue. At some point during the "crunching" process you will either have an epiphany, or you'll reduce things to a point where you can post sample code and data for us to look at.

Note that DBD::AnyData can often be used to provide a self contained script that includes the data, or use DBD::SQLite to populate a database on the fly. If it's a MySQL problem you can use the same technique of populating the database with test data in your sample script, but that reduces the number of monks who may be able to help diagnose the issue somewhat (they'll probably need a MySQL server available).

True laziness is hard work

In reply to Re: DBI SQL Returns Less than Direct SQL by GrandFather
in thread SOLVED: DBI SQL Returns Less than Direct SQL by DaveNagy

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.