can I use ' , ' in INT data type?

Anon

I want to use > < for displaying results from mySQL but the field is for displaying dollars and will need to use a comma for the entries... How can I use > < without using the INT data type?

I'm new to this... in case you can't tell... Any help is appreciated,

thanks

matto

integers cannot hold floating point numbers. either you change the data type, or (if you will have only entire dollar amounts in your table), you can read in the numbers as the are stored and format them afterwards (in the script), e.g. with number_format().

hope I understood ... 🙂

Anon

hi matto, thanks!

What I need to do is to select a range of these entries like WHERE $price > 30 AND < 100 or whatever the code will be - so I can format the $price in the php script to allow for this query to work? Again, thanks for your time...

irving

I ran into the same probem, and I decided to change the field type. After I imported the data into the table, I tried to change the field type to int and it dropped the , and all digits after. Then I decided to import my data into an MS Access table. During the import I changed the data type to currency and the data imported in the format $32,000. Then I exported from Access into my SQL table and it changed the field type to double and it dropped the dollar sign and comma (thousands separator). Just thought I would let you know what I went through. Might not be the best but I am working on other options.