CREATE TABLE `hold_tracker` (
  `id` int(11) NOT NULL auto_increment,
  `STUDENT_ID` int(11) NOT NULL default '0',
  `USER_ID` int(11) NOT NULL default '0',
  `valid` char(1) NOT NULL default '1',
  `date_held` bigint(20) NOT NULL default '0',
  `date_created` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)

This works okay, for just keep track of who is holding the student.
There are some restrictions:

1. A Coordinator may only hold 3 students at a time.  (PHP logic, this
is done already.)
2. A Coordinator can only hold a student while in the #1 position for a
certain amount of time. (I don't have a problem with calculating the
time.The problems are:
        A. What do I do with the record once there hold has expired?

Who checks for this???

If it's user based, then that's easy...Have a user run some type of report, or something like that

But if you/they want this automatic, then it's a little more involved...

What I've done in the past..Running Linux of course...

Create a mysql query text file and save it..(example)

        SELECT STUDENT_ID FROM hold_tracker WHERE USER_ID = 'blah'

Create a bash script...(Example)

mysql database_name -uJoe -pblow <query | mail [EMAIL PROTECTED] -s "Student Name Has Expired"

Then use CRON to start the Bash script at a certain time...


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to