Well, I'm not totally sure, because most of the SQL is out of a forum builder book, so I'm not 100% sure on that, I'll go back and check, otherwise I'll have to re-write the SQL stuff then.

Well if messages.id or thread_id are the same thing then it shouldnt matter, but most likely the thread id is just the parent message id to keep track of threads that are related...i doubt this is your problem

being that this is code from a book, have you verified that your db tables messages or forums have a messages.* field? maybe by making a single simple query for fields that start with messages.?
-Robert
Hopefully there will be a witty sig here at some point

In reply to Re: Script won't retrieve messages column by blaze
in thread Script won't retrieve messages column by stonecolddevin

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.