Variables within Trigger

[TJ Tamagni]

here is my code....

loop
fetch c into f_name, tpe, nll, ky, deflt, extra;
set new_name = NEW.f_name;
set old_name = OLD.f_name;
if new_name != old_name THEN
insert into x(`DateTimeUpdated`,`TableUpdated`,`FieldChanged`,`OldValue`,`NewValue`)
values(NOW(),'x',f_name,old_name,new_name);
END IF;
END LOOP;

so say f_name="ID" i need new_name to equal NEW.ID instead mysql is analyzing it as NEW.f_name and NEW.f_name doesn't exist.

Any suggestions?