mysql trigger

[sujesh Katri]

hi,
i'm trying to execute mysql trigger on my below table but i'm not getting my desirable result..i'm placing my database table ,trigger and my requirement below
database table:

create table quizinfo(
subject varchar(4000),
quizname varchar(4000));

trigger info:

delimiter ££
create trigger quiz
before insert on quizinfo
for each row
begin
insert into quizinfo (quizname)value(quizname)
select quizinfo1.quizname from quizinfo1;
end ££
delimiter;

in quizinfo1 i took only quizname field and i inserted values in it..i'm n't getting quizname values from quizinfo1 to quizinfo..i'm entering subject from html from and inserting into database and before inserting into db i want to store quizname value from quizinfo1 to quizinfo but i'm not getting it..somebody please tell me how i can i achieve this.