Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Comment on

( #3333=superdoc: print w/ replies, xml ) Need Help??

Hmmm, the bad news is: if you don't know any Perl or SQL then I think you will really struggle to get this done - sorry for being a bit brutal here....

Anyway, since this seems to be for a good cause, I think you can get some support here for sure but it may require a bit of work.

So, first of all: when you run this in a browser, can you give us the exact "where clause" and "group clause" you enter into the web form? There are two statements for queries to run against the database in that script and they both take these free-form chunks of SQL code. Since you say yourself that you don't know SQ, my suspicion would be that you entered SQL chunks that don't do what you think they are doing and that the DB is choking on a large amount of data to process.

To get tot he bottom of all this, you need to familiarise yourself with a tool for interacting with your database directly, i.e. someting to run queries against the DB and see the outcome. I would use the MySQL shell in a terminal and I also use this one here quite a bit if I want a GUI and graphical output: DbVisualizer - there is a free version that does all you need to do.
There are of course plenty of other tools to choose from.


In reply to Re: help deriving mysql query from perl script by tospo
in thread help deriving mysql query from perl script by alison-g

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!
  • 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, 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, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • Outside of code tags, you may need to use entities for some characters:
            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.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others chilling in the Monastery: (11)
    As of 2014-10-31 11:57 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      For retirement, I am banking on:










      Results (216 votes), past polls