SQL Error

[NZ_Kiwis]

$result4 = mysql_query("SELECT * FROM forums_replies WHERE TopicID = $TopicID order by ReplyID desc");
while ($row4 = mysql_fetch_array($result4)){

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in E:\wamp\www\\forums\viewtopic.php on line 66

What would be wrong here? $TopicID does hold a value and i've tested it with just a number to make sure. Line 66 is the While like.

[NogDog]

Let PHP tell you what is wrong. Check the return value from the query function. If it is false, use mysql_query() to log the error (or just echo it for now while debugging). I find it useful to put the query into a string before using it, so that the debug info can include the entire query exactly as sent to the DB, too.

$query = "SELECT blah blah blah...";
$result = mysql_query($query);
if($result == false)
{
   user_error(mysql_error() . "<br />\n$query");
   die("DB error");
}
while(blah blah blah) . . .