Null Values

[Aris Santillan]

hi

how to count null values in an array?

tnx

[Bogdan Stancescu]

<?
function countNulls($array)
{
if (!is_array($array)) {
return(NULL);
}
reset($array);
$count=0;
while(list(,$val)=each($array)) {
if ($val===NULL) {
$count++;
}
}
return($count);
}
?>

Aris Santillan wrote:

> hi
>
> how to count null values in an array?
>
> tnx
>

[acidrain9]

Does Anyone know how to exclude a field from a page if its value is null?

this is what i have

a VB detail page and right now it just shows nothing next to all values that
have no values. what i want to do is completly remove all values and labels of
items where the values don't contain anything.

any help would be appreciated.

[Manuel Socarras]

filter the table excluding null values. try this:

SELECT ... WHERE Not IsNull(FIELDX)

HTH,

manuel

acidrain9 wrote:

> Does Anyone know how to exclude a field from a page if its value is null?
>
> this is what i have
>
> a VB detail page and right now it just shows nothing next to all values that
> have no values. what i want to do is completly remove all values and labels of
> items where the values don't contain anything.
>
> any help would be appreciated.
>
>
>IsNull(MyVar)

[acidrain9]

that didn't work, thanks though

i have added the dynamic fields to the right column of a 2 column table
the left column holds the label for the dynamic field.

what i need to do is only show the lable and column of fields that have values.

[Manuel Socarras]

when i said "table" i was refering to the DB, not HTML table. if you
post the code we can take a look

acidrain9 wrote:

> that didn't work, thanks though
>
> i have added the dynamic fields to the right column of a 2 column table
> the left column holds the label for the dynamic field.
>
> what i need to do is only show the lable and column of fields that have values.
>