MySQL return result if 0 rows returned

Question

I have this PHP code:

$query = "SELECT name, COUNT(message) FROM guestbook_message WHERE name='".$req_user_info['username']."' GROUP BY name"; 

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{
    echo "Messages posted: ". $row['COUNT(message)'] ."";
    echo "<br />";
}

Which will show the amount of comments a user has posted.

How do I make it return a value if there is no messages posted from that user? Currently is displays nothing at all. But I want it to show "Messages posted: 0"

Any ideas?

shamittomar · Accepted Answer · 2011-02-18 17:58:01Z

9

Check the number of results returned in result using mysql_num_rows.

$query = "SELECT name, COUNT(message) FROM guestbook_message WHERE name='".$req_user_info['username']."' GROUP BY name"; 

$result = mysql_query($query) or die(mysql_error());

if(mysql_num_rows($result) > 0)
    while($row = mysql_fetch_array($result))
    {
       echo "Messages posted: ". $row['COUNT(message)'] ."";
       echo "<br />";
    }
else
    echo "NO Messages posted. <br />";

answered Feb 18, 2011 at 17:58

shamittomar

46.8k12 gold badges77 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tieme Over a year ago

This gives a warning if the result is 0 rows! PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in...

Brian Driscoll · Accepted Answer · 2011-02-18 18:23:49Z

1

if ($row = mysql_fetch_array($result)) {
    echo "Messages posted: ". $row['COUNT(message)'] . "";
    echo "<br />";
}
else {
    echo "Messages posted: 0";
    echo "<br />";
}

edited Feb 18, 2011 at 18:23

Brian Driscoll

19.7k3 gold badges51 silver badges66 bronze badges

answered Feb 18, 2011 at 17:56

mellamokb

56.8k12 gold badges111 silver badges138 bronze badges

1 Comment

Tom Over a year ago

Thanks mellamokb! I also forgot to put the AND deleted in my WHERE clause. It's been a long day...

Community · Accepted Answer · 2023-11-20 22:45:59Z

0

Replace $row['COUNT(message)'] with the tertiary operator:

( $row['COUNT(message)'] > 0 ? $row['COUNT(message)'] : 0 )

This is basically a compacted if... else... statement.

edited Nov 20, 2023 at 22:45

CommunityBot

11 silver badge

answered Feb 18, 2011 at 18:24

eykanal

27.2k19 gold badges86 silver badges114 bronze badges

Collectives™ on Stack Overflow

MySQL return result if 0 rows returned

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related