how to convert mysql null as 0 in php

kummu4help

hi,
i am executing a query in php.
the query returns a result set which may contain NULL for some of the columns

i want to display this result set as a table.

when a column has null value i want to display it as 0

here i am not allowed to use any conditional statement.

so is there any built in function either in php or mysql that solves my problem

thanks for any help

Dormilich

what about type casting:

Expand|Select|Wrap|Line Numbers

 echo ((int) $var_that_may_be_null);

// prints the variable as integer

how to convert mysql null as 0 in php

re: how to convert mysql null as 0 in php

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about