March 20th, 2000, 08:37 PM
I am trying to set up a table which will hold a price for an item.
I want it to show up like this
How do i get the coumn to show amounts of money with the dollar sign?
March 21st, 2000, 01:23 AM
I don't know whether it is possible to set a currency data type in Mysql.
But probably you may use DECIMAL(M,D) or INTEGER(M,D) datatypes for saving currency values with decimal points.
And finally when you retrive the value from the database you can assaign "$" sign to the value.
More details you can get it from MySql on line manual.
March 21st, 2000, 02:01 AM
You are the greatest ! =)
Thanks for answering my questions, it seems your always aroun. Thanks a lot.
Oh, btw, i have not posted on the perl msg yet, but I got the page working. I do not know exactly what the error was, but i can tell you that i used the Mysql module instead of the DBI module and it worked on the first try, i will elaborate more on the other forum.
March 21st, 2000, 04:47 AM
I come daily this site and post some answers or questions here.
I am learning a lot from here.
Have you solved your problem???