Query help

Hello,

How can a query all of the threads from a certain forum on a php page?


-Artem

It may look something like this:

"SELECT * FROM threads WHERE ForumID = $ForumID AND ThreadType = "normal" ORDER BY DateLastPost";

hmmm this is my code

<?php
//Database connection

$sql = "SELECT * FROM threads WHERE 2 = $ForumID AND ThreadType = 'normal' ORDER BY DateLastPost";


$result = mysql_query($sql);

while ($row = mysql_fetch_assoc($result)) {
echo '<tr><td>';
echo $row['title'];
echo '</td></tr>';
}
?>

And it gives me this error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/webtodes/public_html/chilledsaladfork/index.php on line 44

There could be a few ways to deal with threads...

SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, threadcount
FROM forum AS forum

Now it just shows nothing.

I'm sorry for not being able to get this, I'm not too good with php and MySQL