Count function won't return 0 when counting arrays from the DB

[mschrank99]

$result... (yadda yadda, postgresql query);
$row = pg_fetch_all($result);
$count = count($row);

The strange thing is, $count is never = 0 when there is nothing to be found. It always returns at least a value of 1. Why is this happening?

Thanks,

Matt

[btherl]

If there's nothing to be found, then $row will be set to false.  The value false consists of one item, so counting it will always give you one.

Instead, use

[code]if ($row === false) print "Finished fetching data from database\n";[/code]

[mschrank99]

Thank you very much- I used the following code:

if ($family_accounts != FALSE) {
        $count = count($family_accounts);
}
else {
        $count = 0;
}

[Orio]

If you want a shorter version:
$count = (!family_accounts) ? 0 : count($family_accounts);

Orio.