Checking for data in mysql array

[anders2002]

Hi,

I am trying to see if a mysql query has returned any values:

if (empty($returnedarray)){
Print "No info";
}Else{
Print "There are records"
}

But it doesn't seem to work?

Any ideas?

Cheers,

Anders

 

[sleipnir214]

Try using PHP's mysql_num_rows(). (

http://www.php.net/manual/en/function.mysql-num-rows.php)

______________________________________________________________________

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[anders2002]

Yes, I've tried that but if there are no results return the value for the $returnedarray is literally nothing (not even '0' when i print it to screen), but the empty check fails??? Weird?

 

[sleipnir214]

I don't know what you've done with $returnedarray or what it would contain if the query worked, much less what it would contain if the query didn't.

Empty() checks whether a variable has been set. If you've used it as the LH side of an assignment operation, it's been set. The value does not have to be printable -- FALSE is an example of this.

And the value in $returnedarray is most likely FALSE if it was used as the LH side of an assignment of mysql_fetch_array().

Again, use mysql_num_rows() if you want to see how many rows were returned by a query.

Otherwise, process the return a row at a time:

while ($returnedarray = mysql_fetch_array($reshandle))
{
//process data here
} ______________________________________________________________________

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!