[thelist] SQL - Field Types... *sorted*

[Dave Stevens]

Thanks :)

Dave S

----- Original Message -----
From: "Gary Bland" <Gary at star-chaser.com>
To: <thelist at lists.evolt.org>
Sent: Tuesday, August 20, 2002 11:39 PM
Subject: Re: [thelist] SQL - Field Types...


> Dave Stevens wrote:
> > --
> > [ Picked text/plain from multipart/alternative ]
> > Hi all,
> >
> > I have a table in a MySql database, which contains a field, amongst
others, called "Price" which is not just a clever name - it contains the
price of a product.
> >
> > I need to be able to add up prices on an orderform later on, so what
field type would be best for this field?
> >
> > I saw DECIMAL, is this a good option?
>
> no use float(10,2) default 0.00
>
> HTH
> Gary
>
>
>
>
> --
> Gary Bland
> StarChaser Web Architecture
> http://star-chaser.com
> Building Tomorrow's World Today
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !