[SOLVED] mysql_num_rows

[maxudaskin]

Error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.grable/vzoom/virtualzoom.net/comm/forum_posts.php on line 333

Code:

<?php
while($forum_array = mysql_fetch_array($forum_query)){
							$forum_id = $forum_array['topicid'];
							$replies_sql = "SELECT * FROM forum_posts WHERE topicid = '{$forumid}";
							$replies_query = mysql_query($replies_sql,$conn);
							$replies = mysql_num_rows($replies_query); // Line 333

/* ... Code cut out */
?>

[BlueSkyIS]

add this after your mysql_query():

 

or die(mysql_error());

[maxudaskin]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1' at line 1

 

<!--#include file="../loginscript.php" --> // Line 1

[BlueSkyIS]

there is a missing single quote in your SQL.

[maxudaskin]

That would do it... Thank you.