Stupidly simple question

[filburt1]

Given a threadid (and forumid, if it makes a difference), how can I get the contents of the first post in a thread?

[Freddie Bingham]

$DB_site->query("SELECT * FROM post WHERE threadid = " . intval($threadid) . " ORDER BY dateline DESC LIMIT 1");

.. eh something like that

[Freddie Bingham]

in vb3 you are going to need to do this as no variables will be available in the global scope:

$DB_site->query("SELECT * FROM post WHERE threadid = " . intval($_REQUEST['threadid']) . " ORDER BY dateline DESC LIMIT 1");

[filburt1]

Didn't quite work:$postcontents = $DB_site->query("SELECT * FROM post WHERE threadid = $threadid ORDER BY dateline DESC LIMIT 1");
print $postcontents;

It shows "Resource id #8" instead of the post contents :confused:

[JamesUS]

After that query run:

echo $post[pagetext];

[Admin]

Actually you need to use query_first(), not query()...

[filburt1]

Thanks, a combinations of those two suggestions fixed it :)

[filburt1]

It has to be ASC, not DESC, BTW, it was returning the last post :)

[Admin]

Oh yeah, that too. You can remove the ASC really, it's not needed. :)