Rosst Posted October 27, 2006 Share Posted October 27, 2006 Ok, well I am trying to make comments for my news system on my site.. And I am getting this error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/avexxon/public_html/blah/includes/news.php on line 49, and on line 49 is this code: $commentsnum = mysql_num_rows(mysql_query("select * from newscomments where news = '$_GET[id]' order by id asc limit $from, $max_results"));, you can see here: http://www.vexxon.net/blah/?view=news&act=comments&id=1, thanks in advance for any help Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted October 27, 2006 Share Posted October 27, 2006 When debugging code, it is much better not to nest the function calls so you can figure out what is wrong.Try:[code]<?php$q = "select * from newscomments where news = '$_GET[id]' order by id asc limit $from, $max_results";$rs = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());$commentsnum = mysql_num_rows($rs);?>[/code]Using the above statements should tell you what is wrong.Ken Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.