Okay. I asked this last night at like 2:00 am, figuring that's when the code-monkeys come out, but the monkeys were fairly quiet, so..
I have a table called lets say "price_table"
in that are these colums:
1) serial_number [INT(20)] (Key ID- non sequential but all unique)
2) vendor_price [VARCHAR(20)]
3) my_price [DECIMAL (10,2]
Now,... Vendor price looks like this: $1,234,56 with the dollar sign and the comma.Sooo Igotsta run some code that pulls the vendor_price as varchar, strips the dollar sign and the comma and sticks in back in to the database under my_price on the correct row as a decimal value...
I hope that makes sense..
I have a table called lets say "price_table"
in that are these colums:
1) serial_number [INT(20)] (Key ID- non sequential but all unique)
2) vendor_price [VARCHAR(20)]
3) my_price [DECIMAL (10,2]
Now,... Vendor price looks like this: $1,234,56 with the dollar sign and the comma.Sooo Igotsta run some code that pulls the vendor_price as varchar, strips the dollar sign and the comma and sticks in back in to the database under my_price on the correct row as a decimal value...
I hope that makes sense..