Database help needed.

[lordicon2001]

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.

<?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>';
?>

[kh99]

From what you say, it seems like you'd want "WHERE post.postid = thread.firstpostid".