?

Search Help Board

PHP FAQ
PHP Articles
PHP Help
Bulletin Board

PHP Manual (NEW!)
First Time PHP'ers
Help with programming
Sql assignment help
PHP Homework Help


C# Help

?
?Manage database question
Author:??(---.ny5030.east.verizon.net)
Date:???06-06-03 12:22

Hello,

I have a mysql database. One table is called "students" which list all the students' information, like address, phone number and so on. Every month students have a quiz and get the grades. I want to input the grades in the datbase, because I want to each student using his or her username and password to login the "grade" page to view his or her own current grades and also can view his or her own passed the grades on the internet. How could I store these grades for each month? Another thing is that in future I would add more students in the database. Another words, the database will expend in the future. Please give me some suggestions.

Thanks

?Re: Manage database question
Author:??(---.cpe.net.cable.roger)
Date:???06-07-03 11:25

make a separate table called
'quiz_table' with the following fields
id (int autonumber primary)
quiz_no (int)
student_id (int / varchar depending on id format)
quiz_score

the student_id is the foreign key that can be used to show only that students scores by setting it as a session variable which can be used to query the db

this way it does not matter how many quizzes or how many students are entered...

hth

?Re: Manage database question
Author:??(---.ny5030.east.verizon.net)
Date:???06-09-03 06:02

I got it. Thank you very nuch.

Go to Top??|??Go to Topic??|??Threaded View??|??Search?
??|??
New Topic
?Reply To This Message
?Your Name:
?Your Email:
?Subject:
Email replies to this thread, to the address above.
??

Provided By
Phorum