Re: decimal point
| From: | Ron Piggott | Date: | Sun, 16 Dec 2007 03:13:19 +0000 |
| Subject: | Re: decimal point | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44415@lists.php.net to get a copy of this message | ||
INSERT INTO rate_plans VALUES ( '12', 'One Week', '1', '2',
'2',
'8.00' )
When I use
$advertisement_rate = mysql_result($rate_plan_result,0,"rate");
$advertisement_rate has a value of 800 instead of 8.00 --- how can I get
my 2 decimal places back?
Ron
On Sat, 2007-12-15 at 18:18 -0800, Micah Stevens wrote:
> What's your insert statement?
>
> On 12/15/2007 05:11 PM, Ron Piggott wrote:
> > How do I get the decimal point back when I am retrieving from a column
> > that is set up as:
> >
> > rate decimal(4,2)
> >
> > Example: Right now it is giving me 800 instead of 8.00
> >
> > Ron
> >
> >