php number_format，从存储过程中隐藏null

Question

I use sql server stored proc in my php project. In a table, there are some columns has numbers and some others are only empty (NULL in the sql stored proc). But when i use number_format, it appear 0. That's not what i want, i would like to have empty space. Is it possible? Here what i have until now :

<td style="text-align: right">
<?php echo number_format($row['Quantite']) . " ";
if (is_null($row['Quantite'])){ echo ' ';}?></td>

Thank you to help me!

Answer 1

Something like this?

Edit the second param of number_format (2) for more decimals.

echo is_null($number) ? ' ' : number_format($number, 2, ",", " ") . "$ ";