ChrisLawrie

Hi all i need help! I am trying to create a table of 10 latest posts from my forums on the first page of my site. I have tried the following code but errors occur: <h1>LAST 10 POSTS</h1> <table border=\"1\"> <tr> <td class=\"white\"><strong>Topic ID</strong></td> <td class=\"white\"><strong>Topic Title</strong></td> <td class=\"white\"><strong>Topic Time</strong></td> <td class=\"white\"><strong>Topic Views</strong></td> <td class=\"white\"><strong>Forum ID</strong></td> <td class=\"white\"><strong>Forum Name</strong></td> <td class=\"white\"><strong>User Name</strong></td> </tr> <?php mysql_pconnect(\"localhost\",\"***\",\"***\"); $query=\"SELECT topic_id, topic_title, topic_time, topic_views, t.forum_id, f.forum_name, u.uname FROM \".$mpnTables.\" t, \".$mpnTables.\" f, \".$mpnTables.\" u where (f.forum_id=t.forum_id) and (forum_type \'1\') and (t.last_post=u.uid) ORDER BY topic_time desc LIMIT 10\"; $result=mysql_db_query(\"***\",$query); while($row=mysql_fetch_row($result)){ ?> <tr> <td class=\"white\"><?php print($row[0]);?></td> <td class=\"white\"><?php print($row[1]);?></td> <td class=\"white\"><?php print($row[2]);?></td> <td class=\"white\"><?php print($row[3]);?></td> <td class=\"white\"><?php print($row[4]);?></td> <td class=\"white\"><?php print($row[5]);?></td> <td class=\"white\"><?php print($row[6]);?></td> </tr> <?php } mysql_free_result($result); ?> </table> Gives following errors: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in ***/index2.php on line 170 Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in ***/index2.php on line 183 Any suggestions anyone? My tables are called: mpn_topics, mpn_forums,mpn_users. Cheers