Commas Missing.

[Braulio Lumbreras]

Hello everyone,

I have a table with a column for real estate property values. The format of
the column is float(8,2). When the results are presented on the web page I
get $155000.00 versus $155,000.00. How do I go about getting the comma in
the values. I am using a MySql table.

Thanks in advance, Braulio.

[rob::digitalburn]

Well, mySQL doesn't store the comma (as far as I know), so you'll need to
add one yourself using PHP (or whatever language you're using). I suspect
that there's a function for doing just this, but it would be very easy with
a bit of string manipulation.


Braulio Lumbreras wrote:

> Hello everyone,
>
> I have a table with a column for real estate property values. The
> format of the column is float(8,2). When the results are presented
> on the web page I get $155000.00 versus $155,000.00. How do I go
> about getting the comma in the values. I am using a MySql table.
>
> Thanks in advance, Braulio.

[Diego Nunes]

There's a function called currency (or with a name that contains
"currency", like formatCurrency or something...), if you're using PHP.
But, as was said, some string functions do it easily.

[]s

--
~~ ~
diego nunes
web engineer
~ ~~

[Braulio Lumbreras]

I looked up in my PHP and MySql book and was unable to find the function.
Does anyone know what the function is named ?

Any help will be appreciated, Braulio.

"Diego Nunes" <dnunes.spam.please@gmail.com> wrote in message
news:cdab09$g3a$1@forums.macromedia.com...

> There's a function called currency (or with a name that contains
> "currency", like formatCurrency or something...), if you're using PHP.
> But, as was said, some string functions do it easily.
>
> []s
>
> --
> ~~ ~
> diego nunes
> web engineer
> ~ ~~
>
>

[rob::digitalburn]

Try searching [url]www.php.net[/url].


Braulio Lumbreras wrote:

> I looked up in my PHP and MySql book and was unable to find the
> function. Does anyone know what the function is named ?
>
> Any help will be appreciated, Braulio.
>
> "Diego Nunes" <dnunes.spam.please@gmail.com> wrote in message
> news:cdab09$g3a$1@forums.macromedia.com...

>> There's a function called currency (or with a name that contains
>> "currency", like formatCurrency or something...), if you're using
>> PHP. But, as was said, some string functions do it easily.
>>
>> []s
>>
>> --
>> ~~ ~
>> diego nunes
>> web engineer
>> ~ ~~

[Diego Nunes]

Errr.. sorry for the wrong name, I think "currency" is a function
from another language. Anyway, I found "money_format" that "Formats a
number as a currency string" (its in the manual).
I hope it helps you.

[]s

--
~~ ~
diego nunes
web engineer
~ ~~

[Braulio Lumbreras]

I found the function at php.net. How do I go about addding this function to
my web page using DreamWeaver ?
<?php

$number = 1234.56;

// english notation (default)
$english_format_number = number_format($number);
// 1,234



Thanks in advance, Braulio.

"Diego Nunes" <dnunes.spam.please@gmail.com> wrote in message
news:cdbigs$ma0$1@forums.macromedia.com...

> Errr.. sorry for the wrong name, I think "currency" is a function
> from another language. Anyway, I found "money_format" that "Formats a
> number as a currency string" (its in the manual).
> I hope it helps you.
>
> []s
>
> --
> ~~ ~
> diego nunes
> web engineer
> ~ ~~
>
>

[Diego Nunes]

Go to "code mode" and be happy ;)

[]s


--
~~ ~
diego nunes
web engineer
~ ~~

[Braulio Lumbreras]

I get the error below on the web page when I add the code.

Parse error: parse error in
/home/swisherm/public_html/residentialhouseforsalelistingstest.php on line
115

The code is shown below.

<td>$<?php echo
$row_residential['Price'];english_format_number='Price'?>&nbsp; </td>

Please advise, thanks in advance. Braulio.


"Diego Nunes" <dnunes.spam.please@gmail.com> wrote in message
news:cdc75i$ajb$1@forums.macromedia.com...

> Go to "code mode" and be happy ;)
>
> []s
>
>
> --
> ~~ ~
> diego nunes
> web engineer
> ~ ~~
>
>

[Braulio Lumbreras]

Thanks Diego and Rob. I got it going.

Thanks for your help, Braulio.

"Braulio Lumbreras" <brauliolumbreras@websitemedia.net> wrote in message
news:cdcm2c$m7m$1@forums.macromedia.com...

> I get the error below on the web page when I add the code.
>
> Parse error: parse error in
> /home/swisherm/public_html/residentialhouseforsalelistingstest.php on line
> 115
>
> The code is shown below.
>
> <td>$<?php echo
> $row_residential['Price'];english_format_number='Price'?>&nbsp; </td>
>
> Please advise, thanks in advance. Braulio.
>
>
> "Diego Nunes" <dnunes.spam.please@gmail.com> wrote in message
> news:cdc75i$ajb$1@forums.macromedia.com...

> > Go to "code mode" and be happy ;)
> >
> > []s
> >
> >
> > --
> > ~~ ~
> > diego nunes
> > web engineer
> > ~ ~~
> >
> >

>
>

[rob::digitalburn]

No worries ;)

Braulio Lumbreras wrote:

> Thanks Diego and Rob. I got it going.
>
> Thanks for your help, Braulio.
>
> "Braulio Lumbreras" <brauliolumbreras@websitemedia.net> wrote in
> message news:cdcm2c$m7m$1@forums.macromedia.com...

>> I get the error below on the web page when I add the code.
>>
>> Parse error: parse error in
>> /home/swisherm/public_html/residentialhouseforsalelistingstest.php
>> on line 115
>>
>> The code is shown below.
>>
>> <td>$<?php echo
>> $row_residential['Price'];english_format_number='Price'?>&nbsp; </td>
>>
>> Please advise, thanks in advance. Braulio.
>>
>>
>> "Diego Nunes" <dnunes.spam.please@gmail.com> wrote in message
>> news:cdc75i$ajb$1@forums.macromedia.com...

>>> Go to "code mode" and be happy ;)
>>>
>>> []s
>>>
>>>
>>> --
>>> ~~ ~
>>> diego nunes
>>> web engineer
>>> ~ ~~