trtcom1

Hi there, I have 3 tables: Student ([B]studentNum,firstName,lastName,CourseName)[/B], course ([B]courseID,courseTotalCapacity[/B]), course_allocation ([B]studentNum,courseID[/B]). I have 3 courses, MATHS=101,BIOLOGY=102,CHEMISTRY=103. My form has the following: [CODE=html]<SELECT NAME="CourseName"> <OPTION VALUE="MATHS">MATHS</OPTION> <OPTION VALUE="BIOLOGY">BIOLOGY</OPTION> <OPTION VALUE="CHEMISTRY">CHEMISTRY</OPTION> </SELECT></td></tr> <SELECT NAME="courseID"> <OPTION VALUE="101">MATHS=101</OPTION> <OPTION VALUE="102">BIOLOGY=102</OPTION> <OPTION VALUE="103">CHEMISTRY=103</OPTION> </SELECT> [/CODE] I would like to have some kind of a …

Hi there, I am having problems with editing/updating a record. I have 3 tables: Student (studentNum,firstName,lastName,ClassRoom), course (courseID,courseTotalCapacity), course_allocation (studentNum,courseID). I have 3 courses, MATHS=101,BIOLOGY=102,CHEMISTRY=103. The total number of students allowed for each of the 3 courses is courseTotalCapacity = 20. Meaning that only 20 students can register for MATHS, …

Hi there, I am trying to implement a confirmation dialog box before deleting a record in a table that have. I created a MYSQL table called manager with columns: [B]Table manager[/B] [I]managerID firstName lastName Department[/I] I use a while loop to display the records of every manager in the database …

Hi, I need somebody to have a look at my code below and help to see what I have done wrong. I have 3 tables:[B]Student[/B] [I][COLOR="Red"](studentNum,firstName,lastName)[/COLOR][/I], [B]course[/B] ([COLOR="Red"][I]courseID,courseTotalCapacity[/I][/COLOR]), [B]course_allocation[/B] ([I][COLOR="Red"]studentNum,courseID[/COLOR][/I]). The AIM is to allocate students to 2 classes (courses 101 and 102) as long as there is available space …