Need help with awaiting table or idea!

[msimonds]

I have finished the admin area for a student/teacher system I am building and now wanted to attack the front end. I wanted to get some feedback on one of the functions that I am persuing.

1) I want Parents to have the ability to register their students on the front end.

2) My thought is to store the information in temp table and then have it show up in the admin area as "students awaiting approval" or something to that affect.

3) send a confirmation email to the parents showing that their registration information has been received.

4) once the student has been approved, have some function insert the data into the students table and remove it from the Temp table.

I would appreciate any feedback on this!!!

Thanks in advance

Mike

[devinemke]

why bother with a temp table. just store everyone in the same table with some sort of BOOLEAN field that you can flip when they are approved.

[msimonds]

CREATE TABLE `students` (
  `student_id` int(10) unsigned NOT NULL auto_increment,
  `student_fname` varchar(100) NOT NULL default '',
  `student_lname` varchar(100) NOT NULL default '',
  `student_bdate` varchar(10) NOT NULL default '',
  `student_age` int(3) NOT NULL default '0',
  `student_address1` varchar(100) NOT NULL default '',
  `student_address2` varchar(100) default NULL,
  `student_city` varchar(100) NOT NULL default '',
  `student_state` varchar(100) NOT NULL default '',
  `student_zip` int(5) NOT NULL default '0',
  `student_father` varchar(100) default NULL,
  `student_mother` varchar(100) default NULL,
  `student_contact` varchar(12) NOT NULL default '',
  `teacher_id` int(2) NOT NULL default '0',
  `student_email` varchar(100) default NULL,
  `student_allergies` varchar(100) default NULL,
  PRIMARY KEY  (`student_id`)
) TYPE=MyISAM AUTO_INCREMENT=38 ;

Can you give me an idea of what you mean. Are you referring to a switch or something!!!

So when the parent registers the student, it will set that to lets say "false" and then once approved in the admin area, the update will switch it to student=true

am i headed in the right direction!!

[devinemke]

add an integer field call "approved" and set it to 1 or 0 depending on their approval status. or if it is important to know when they were approved make the "approved" field a DATE or DATETIME type that defaults to NULL and only fill it in with the current date when they are approved.

BTW: you don't really need to store the student's age. you have their birthdate and you know the current date thus it is pretty simple math to calculate the difference. (one less field to maintain.)

[msimonds]

Thanks devinemke! You are a gentleman and a scholar and have helped me a lot in the past.

I will take it from that angle by creating a new field in the table!

Also thanks for the birthday change, I did not even think about it, need to work on the calculations and will apply those changes as well