If i want to make a trigger so that when I insert some data into a
set table one of the fields will contain an sql query, I want to then
execute that sql as a trigger.

ie:

insert into table (field1,sql1) values ('something', 'insert into
sql_table (f1,f2,f3) values (\'a\',\'b\',\'c\')');

then it would run the trigger for the insert into sql_table....

if there is no easy way of doing it with a trigger then I could just
code it into php,asp,cold fusion or what ever it will be done in.

Any suggestions would be appreciated however