Help with an IF Else statement & MySQL

[Jack Franklin]

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:

PHP: Select all

$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:

PHP: Select all

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

Thank you!

[Marc]

Why not count the rows on your comments query??

so your IF would look like:

PHP: Select all

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

[Rakuli]

Check how many rows were retrieved link this

PHP: Select all

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]

PHP: Select all

$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]

PHP: Select all

<?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]

Thanks guys. I'll try it now

Rakuli, yours works perfectly. Thanks for the help guys