Member Avatar

otooleb6

hey,

I am having some trouble with this one. I am doing a student web organiser.The user registers details which goes into userinfo and sem1week1. My three tables are:


1.userinfo:
firstname, lastname, e-mail, username, password, coursecode, courseyear.

2.courseinfo:
subject, time, day, semester, coursecode, courseyear.

3.sem1week1:
username, coursecode, courseyear, day, time, subject, event, semester

The coursecode, courseyear and username go in perfectly at registration. I just cant get the day, time and subject from courseinfo into sem1week1.

Can anyone help me

I will restrain from lecturing on normalization. I assume you've probably never heard of it but I'd highly recommend looking into it.

What does your insert look like?