Thread Data on Alternate vB Page

[GuruXL]

How can I get Thread data from threads I make to show up on another vBulletin page, just the post and the thread title, how can I do that?

Please someone help me!

[Andreas]

PHP Code:

$thread = $DB_site->query_first("SELECT thread.*,post.* FROM " . TABLE_PREFIX . "thread AS thread
                                 LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid=thread.firstpostid)
                                 WHERE thread.threadid=$threadid"); 


Instead of thread.*,post.* you can restrict it to the fields you really need.
So if you only want Author, Title, Date and Text this would be

thread.postusername, tread.title, thread.dateline, post.pagetext

[GuruXL]

I don't think it will work.

[Andreas]

Hmm ... why not?

[GuruXL]

Cause when I tried it I got a SQL error.

[Andreas]

Can you post the error message?

Did you set $threadid before executing this code?