vb.org Archive - Database help needed.

I am currently trying to make a new section on my external vb site which displays a bit of information from the forums itself. I was going to use vbulletins external.php for the rss then decided that I need it to be more then just that so let me try and explain a bit then show you what I have so far.

I am making a query that pulls information from both db.thread and db.post, when pulling from db.thread alone everything works, however when i try to add db.post so that I can display a bit of the first post(actual post) as well i end up screwing it all up. Its pulling more then I wanted and some things not at all. Hope by showing my code you get a better idea of what I am doing.

Also trying to shorten the post itself to only display like the first 20 chars.

Code:

<?php

$result1 = mysql_query("SELECT * FROM thread, post WHERE thread.threadid = post.threadid AND thread.forumid = 20 ORDER BY thread.lastpost DESC LIMIT 0,50");

echo '<table border="1">

        <tr>

            <th>Thread</th>

            <th># Posts</th>

            <th># Views</th>

            <th>Last Poster</th>

                <th>Posted By</th>

                <th>Post</th>

    </tr>';

if($result1 === FALSE) {

    die(mysql_error()); 

}

while($row1=mysql_fetch_array($result1))

{ 

        echo'<tr align="middle">';

        echo'<td class="alt2" align="left"><a href="http://WEBSITE/showthread.php?t=' . $row1['threadid'] . '/" target="_blank">' . $row1['title'] . '</a></td>';

        echo'<td class="alt1">' . $row1['replycount'] . '</td>';

        echo'<td class="alt2">' . $row1['views'] . '</td>';

        echo'<td class="alt1"><a href="http://WEBSITE/member.php?u=' . $row1["lastposterid"] . '">' . $row1["lastposter"] . '</a></td>';

        echo'<td class="alt2"><a href="http://WEBSITE/member.php?u=' . $row1["postuserid"] . '">' . $row1["postusername"] . '</a></td>';

        echo'<td class="alt1">' . $row1["pagetext"] . '</td>';

        echo'</tr>';

}

echo'</table>';

?>

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01114 seconds Memory Usage 1,712KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: