SQL Statement in PHP to modify table in MySQL

[webproclaim]

I'm trying to change a field in a MySQL database from a text field to a decimal field. Below is a sample of what I am trying to do but it is not working as there is something wrong with the syntax.

Would someone mind showing me a 'fixed' version of the code below. Thanks.

$ModifyTable = "ALTER TABLE  tablename CHANGE fieldname fieldname DECIMAL(10,2) DEFAULT NULL";

[fenway]

I thought you needed to say CHANGE COLUMN... and I always use MODIFY instead, since that way you don't have to repeat the fieldname.