Checking if an array is empty using a while loop

Question

I have read several of these posts on the site, but still can't find the answer to my problems. I have a while loop where for every entry in the database the table populates. Although if the table in the database is empty, I want it to display a messaged instead. Any ideas of what is wrong here? (aware of the deprecated tags)

$result = mysql_query("SELECT * FROM blog");

while($row = mysql_fetch_array($result))                    
{           
   if(count($row) === 0)
   {
      echo 'No Data';
   }

   <table code>

}

However, mysql_* functions are officially deprecated. I recommend you to use PDO or mysqli instead. — mpyw
– mpyw, Commented Jun 9, 2014 at 12:30
The problem is that the if is inside the while so it will never be reached — LatinSuD
– LatinSuD, Commented Jun 9, 2014 at 12:31

pavel · Accepted Answer · 2014-06-09 12:29:57Z

3

Use mysql_num_rows for counting rows from DB.

<?php

if (mysql_num_rows($result) > 0) {
    echo '<table>';
    while ($row = mysql_fetch_assoc($result)) {
        echo '<tr>...</tr>';
    }
    echo '</table>';
} else {
    echo 'No result found';
}

?>

EDIT: updated code for table.

answered Jun 9, 2014 at 12:29

pavel

27.3k11 gold badges47 silver badges63 bronze badges

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

Comments

prava · Accepted Answer · 2014-06-09 12:30:11Z

2

$result = mysql_query("SELECT * FROM blog");

if(mysql_num_rows($result) === 0) {
    echo 'No Data';
} else {
    while($row = mysql_fetch_array($result)) {           
        // code
    }
}

answered Jun 9, 2014 at 12:30

prava

3,9762 gold badges26 silver badges35 bronze badges

Comments

Rakesh Sharma · Accepted Answer · 2014-06-09 12:30:58Z

1

use mysql_num_rows() to get count of query result rows

$rows = mysql_num_rows($result);
if($rows > 0) {
  // do your stuff
}

answered Jun 9, 2014 at 12:30

Rakesh Sharma

13.7k5 gold badges41 silver badges44 bronze badges

Comments

Surinder ツ · Accepted Answer · 2014-06-09 12:32:40Z

1

Use mysql_num_rows for counting number of rows are returned in query.

answered Jun 9, 2014 at 12:32

Surinder ツ

1,7883 gold badges17 silver badges27 bronze badges

Comments

Ayaz Shah · Accepted Answer · 2014-06-09 12:33:12Z

1

Try this. mysql_num_rows will check the records in database. On true condition it will allow to execute the while loop other wise else condition will execute.

 $result = mysql_query("SELECT * FROM blog");

    if(mysql_num_rows($result) > 0) {
        echo 'No Result Found';
    } else {
        while($row = mysql_fetch_array($result)) {           
            // Here your Data
        }
    }

answered Jun 9, 2014 at 12:33

Ayaz Shah

4351 gold badge5 silver badges24 bronze badges

Comments

Nithyanandhan M · Accepted Answer · 2014-06-09 12:33:52Z

1

If you want to display when no record found then

  $result = mysql_query("SELECT * FROM blog");

  while($row = mysql_fetch_array($result))

  {           
  if(count($row) == 0 || count($row) < 1)
   {
    echo 'No Data';
   }
  else
     {
  //print records

      }
  }

answered Jun 9, 2014 at 12:33

Nithyanandhan M

1,5541 gold badge16 silver badges28 bronze badges

Collectives™ on Stack Overflow

Checking if an array is empty using a while loop

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related