[SOLVED] List of Blog comments not displaying

[joshgarrod]

Hi, I am trying to create a page that list comments that have been submitted about articles in my blog. The list is for the admin side so that he / she can send them live or delete them. However, for some reason they won't even display. The warning I am getting and my code is below. Thanks in advance

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Users\website\accept_decline_comments.php on line 56

 

<?php

			error_reporting (E_ALL ^ E_NOTICE);
    $usr = "usr";
    $pwd = "pwd";
    $db = "quest";
    $host = "host";

    # connect to database
    $cid = mysql_connect($host,$usr,$pwd);
    if (!$cid) { echo("ERROR: " . mysql_error() . "\n");    }

			$query = mysql_query("SELECT * FROM comments ORDER BY ref");	

			   if(mysql_num_rows($query)==0){

				echo "<p>There are currently no new comments</p>";

				  }else{

					while($info = mysql_fetch_array($query)){

					$ref = $info ['ref'];						
					$comment = $info ['comment'];
					$name = $info ['name'];
					$submitted = $info ['submitted'];
					$live = $info ['live'];

					if ($live == "No") {

					echo "<p>Comment by - $name on $submitted</p>
					<p>$comment</p>
					<p><a href=\"accept_comment.php?ref=$ref\">Go live</a> | <a href=\"delete_comment.php?ref=$ref\">Remove</a></p>
					<hr class=\"hr\" width=90%>";
					}
					else {
					}
					}
					}
			?>

[Jibberish]

You need to select the database

 

<?php
mysql_select_db($db, $cid);
?>

 

and also with the mysql query you need to pass the link through as well (I think)

 

<?php
$query = mysql_query("SELECT * FROM comments ORDER BY ref", $cid);   
?>

[joshgarrod]

Nice one thanks, I missed that.