Member Avatar



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:

firstname, lastname, e-mail, username, password, coursecode, courseyear.

subject, time, day, semester, coursecode, courseyear.

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?