elainemurphy2
-
Posts
5 -
Joined
-
Last visited
Never
Posts posted by elainemurphy2
-
-
I really need help with this!!
Have THREE database tables
COURSEINFO---
Field Type
-----------------------
CourseCode varchar(10)
Semester int(1)
CourseYear int(1)
Day varchar(10)
Time varchar(5)
Subject varchar(100)
WEEKTIMETABLE
---------------
UserId varchar(10)
day varchar(10)
Time varchar(10)
Subject varchar(100)
CourseCode varchar(10)
Semester int(1)
CourseYear(1)
Userinfo
---------------
UserId int(11)
firstname varchar(15)
lastname varchar(20)
username varchar(15)
password varchar(20)
email varchar(20)
coursecode varchar(10)
courseyear int(1)
the user enters in all their details at regestration then they login into the system. I have all the seperate course information in course info. The main aim of the program is to be able to make a unique timetable for each member. I want an php statment that transfers all the course info rows depending on what course and year the user picks during registration. However as there is no userid in courseinfo and this is the unique idenitfier for the timetable and is necessary to extract it how will i do this???
many thanks for your help!its very urgent!!
-
I really need help with this!!
Have THREE database tables
COURSEINFO---
Field Type
-----------------------
CourseCode varchar(10)
Semester int(1)
CourseYear int(1)
Day varchar(10)
Time varchar(5)
Subject varchar(100)
WEEKTIMETABLE
---------------
UserId varchar(10)
day varchar(10)
Time varchar(10)
Subject varchar(100)
CourseCode varchar(10)
Semester int(1)
CourseYear(1)
Userinfo
---------------
UserId int(11)
firstname varchar(15)
lastname varchar(20)
username varchar(15)
password varchar(20)
email varchar(20)
coursecode varchar(10)
courseyear int(1)
the user enters in all their details at regestration then they login into the system. I have all the seperate course information in course info. The main aim of the program is to be able to make a unique timetable for each member. I want an php statment that transfers all the course info rows depending on what course and year the user picks during registration. However as there is no userid in courseinfo and this is the unique idenitfier for the timetable and is necessary to extract it how will i do this???
many thanks for your help!its very urgent!!
-
Hi,
Im looking to make a timetable system for students that can input data which will be entered into the database and then constructed into the database!ive done the whole data insert thing but need help retreving information from the database to make a timetable format with the information in the cells!!can anybody help??would really appreciate it!
linking tables
in MySQL Help
Posted
This is a student web organiser.
I really need help with this!!
Have THREE database tables
COURSEINFO---
Field Type
-----------------------
CourseCode varchar(10)
Semester int(1)
CourseYear int(1)
Day varchar(10)
Time varchar(5)
Subject varchar(100)
WEEKTIMETABLE
---------------
username varchar(10)
day varchar(10)
Time varchar(10)
Subject varchar(100)
CourseCode varchar(10)
Semester int(1)
CourseYear(1)
Userinfo
---------------
firstname varchar(15)
lastname varchar(20)
username varchar(15)
password varchar(20)
email varchar(20)
coursecode varchar(10)
courseyear int(1)
the user enters in all their details at regestration then they login into the system. I have all the seperate courses information in course info. The main aim of the program is to be able to make a unique timetable for each member. I want an php statment that transfers all the course info rows depending on what course and year the user picks during registration. However as there is no username in courseinfo and this is the unique idenitfier for the timetable and is necessary to extract it how will i do this???
not sure at all but something like
select username.userinfo , coursecode.userinfo , courseyear.userinfo , day.courseinfo , time.courseinfo, subject.courseinfo,
from userinfo and courseinfo
where username = (user that just registered) AND courseyear = (course that the user just entered) AND coursecode = (course code that user just entered)
and insert that select statement into the weeklytimetable table
is this possible or is there another way of doing it ?
example of tables
course info
----------
course code-CA316, CA316
semester1, 1
courseyear 1, 1
day MONDAY, TUESDAY
time 09.00, 10.00
subject LECTURE, PARTY
USERINFO
---------
firstname - john, paul
lastname - brown, murphy
username - johnb, paulm
password - ****, ****
email - ifi@fd , ds@fjd
coursecode- ca136, ca136
courseyear - 1, 1
WEEKLYTIMETABLE--
username - johnb, johnb
day -monday, tuesday
time -9.00, 10.00
subject -lecture, party
coursecode - ca316, ca316
semester -1, 1
courseyear -1, 1
many thanks for your help!its very urgent!!