Make sure the selected array is empty or not PHP?

Question

I am trying to check if mysql_fetch_array () returns an empty array or not. But my code does not seem to work. Here I want to make sure that if the array is empty, I want to display a construction message.

The code:

$queryContents= queryMembers(); $exeQuery = mysql_query($queryContents); while($fetchSet = mysql_fetch_array($exeQuery)) { if(count($fetchSet) == 0) { echo "This Page is Under Construction"; }else{ // something else to display the content } } 

How to check to perform such a function?

Answer 1

use mysql_num_rows to count the number of rows. try it.

 $exeQuery = mysql_query($queryContents); if(mysql_num_rows($exeQuery)== 0){ echo "This Page is Under Construction"; } else{ while($fetchSet = mysql_fetch_array($exeQuery)) { // something else to display the content } } 

Answer 2

You really have to use mysql_num_rows http://us2.php.net/manual/en/function.mysql-num-rows.php

However, on the side of the note, you should use php empty() . http://us2.php.net/empty

Answer 3

When you use mysql_fetch_array (), it returns the rows from the data set one by one when you use the while loop.

If there is no record, while the loop will not be executed. In this case, declare the boolean variable and make it true if it enters the while loop. How:

 $queryContents= queryMembers(); $exeQuery = mysql_query($queryContents); $recordExists = 0; while($fetchSet = mysql_fetch_array($exeQuery)) { if($recordExists == 0 ) $recordExists = 1; // something else to display the content } if($recordExists == 0 ){ echo "This Page is Under Construction"; } 

Hope it works!

Answer 4

You can do it as follows:

 while($r[]=mysql_fetch_array($sql)); // now $r has all the results if(empty($r)){ // do something } 

source: php doc

Answer 5

try it

 if(empty($fetchSet) { echo "This Page is Under Construction"; } else { // something else to display the content } 

Answer 6

Your code inside the while loop never runs if there are no results. mysql_fetch_array returns null / false if there are no more results. What you need to do is first check with mysql_num_rows, before that.

 $queryContents= queryMembers(); $exeQuery = mysql_query($queryContents); if(mysql_num_rows ($exeQuery) == 0) { echo "This Page is Under Construction"; } while($fetchSet = mysql_fetch_array($exeQuery)) { // something else to display the content }