Changing a int variable to a double

[Bob_PHP_Builder]

Hey how can i change a nt variable to a double... is it possible without deleteing the information i have in the tables? I am using the sql prompt at the moment to enter sql queries...

Im new so excuse my lack of knowledge

[thorpe]

Your question is a little jumbled. Do you want to change a fields data type in a database or switch a variables type within php?

[Bob_PHP_Builder]

apologies all, change a fields data type in a database

[madwormer2]

ALTER TABLE `table` CHANGE `column` `column` DOUBLE;