Member Avatar for 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

  • 2 Contributors
  • 1 Reply
  • 82 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by buddylee17
Member Avatar for buddylee17

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.