$h=mysql_query("SELECT *,date_format(CommentDate, '%M %d, %Y') AS CommentDate FROM tblpublicationscomment WHERE ApprovalStatus=1 AND PublicationID='".$_GET['PublicationID']."'");
if(mysql_num_rows($h)>0) {
while($row=mysql_fetch_array($h)) {
echo "
".$row['CommentName']." on ".$row['CommentDate']."
";
echo "
".$row['CommentContent']."
";
} }else{ echo "No comment for this publication"; }
?>