Numeric Database Fields

[Anon]

I have a PHP script that reads NUMERIC(10,2) fields from an Interbase 6 database. Later it print this numbers.

The problem is that all numbers that have the format ###,0[1-9] were printed in the format ###,[1-9]. The zero dissapears.

Ex:

325,05 was printed 325,5

Is this a bug? How can I solve this problem?

Best regards,

Eduardo Ruhland

[Anon]

//zerofill to desired digits

if (strlen($num) < 2)
{
$num = 0 . $num;
}

So if you get 2 as $num, the above will print it out as 02.

Richie.

geocities.com/akindele/

[Anon]

Does this happen if you store them with a period for a decimal point?

If not, then you need to tell your database how to use a , as a decimanl point. or use a period, and use a str_replace to change it back and forth, but that's a bit of a kluge.

It sounds like it's storing two numbers, and that's why the , is lowing the leading zeros, it thinks the 02 in 192,02 is just the number 02, and truncates the leading space.