[mcyates]

That stats.php does not work. I get this error:


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/myfootba/public_html/discussion/stats.php on line 19

try it yourself: http://www.myfootballforum.com/discussion/stats.php



BELOW IS THE CODE INSDE stats.php:

==========================




<?php

echo "<pre>";
$result = mysql_query("SELECT t.threadid,
t.title,
t.lastposter,
t.replycount,
t.views,
t.forumid,
f.title,
t.lastpost

FROM thread AS t,
forum AS f

WHERE t.forumid = f.forumid
ORDER BY t.lastpost DESC
LIMIT 30");
while ($bits = mysql_fetch_array($result))
{
print_r($bits);
}

?>










===============================