Help with an IF Else statement & MySQL

Jack Franklin · January 18th, 2008, 03:36 PM

I know this is an obvious question, but I cannot find an answer!

At the moment the page simpyl displays nothing if there are no comments in the database. I would like it to display something like 'There are no comments yet.'. This is the code for displaying the comments:

Code:


			
$display_comments = @mysql_query("SELECT commentsunique, commentsid, name, comment FROM comments WHERE commentsid='$contentid' ORDER BY commentsunique DESC");
while ($comments = mysql_fetch_array($display_comments)) {
$commentid = $comments['commentsid'];
$name = $comments['name'];
$comment = $comments['comment'];
echo '<h5 class="commentsname">' . $name . '</h5>';
echo '<p class="commentstext">' . $comment . '</p>';

It would be something like:

Code:


			
IF (there are no comments) {
echo '<p>No comments</p>';
} else {
display comments...
}

Thank you!

Marc · January 18th, 2008, 03:43 PM

Why not count the rows on your comments query??

so your IF would look like:

Code:


			
if($rows_count >= 1) {
//show the comments
} else {
// no comments to show!
print "Sorry, currently there are no comments to show";
}

Rakuli · January 18th, 2008, 03:45 PM

Check how many rows were retrieved link this

Code:


			
if (!mysql_num_rows($display_comments))

         echo 'Oh no! There\'s no comments. This is so sad for me :( ';

else {

 // do other stuff here

}

Bravo81 · January 18th, 2008, 03:46 PM

Code:


			
$display_comments = @mysql_query("SELECT commentsunique, commentsid, name, comment FROM comments WHERE commentsid='$contentid' ORDER BY commentsunique DESC");
while ($comments = mysql_fetch_array($display_comments)) {
$commentid = $comments['commentsid'];
$name = $comments['name'];
$comment = $comments['comment'];
if ($comments == 0) {
echo '<p>There are no comments</p>'
} else {
echo '<h5 class="commentsname">' . $name . '</h5>';
echo '<p class="commentstext">' . $comment . '</p>';

I think?
Good luck

~Dean

Marc · January 18th, 2008, 03:50 PM

Code:


			
<?php
$display_comments = @mysql_query("SELECT commentsunique, commentsid, name, comment FROM comments WHERE commentsid='$contentid' ORDER BY commentsunique DESC");
$rows = mysql_num_rows($display_comments);
if($rows >= 1) {
    while ($comments = mysql_fetch_array($display_comments)) {
    $commentid = $comments['commentsid'];
    $name = $comments['name'];
    $comment = $comments['comment'];
    echo '<h5 class="commentsname">' . $name . '</h5>';
    echo '<p class="commentstext">' . $comment . '</p>'; 
    }
} else {
    // no commetns to show
}
?>

Jack Franklin · January 18th, 2008, 04:08 PM

Thanks guys. I'll try it now

Rakuli, yours works perfectly. Thanks for the help guys