Hi, A 'hold' is a time period in which a Coordinator has to place the specific student with a Host Family.
Coordinators can hold a specific student for up to 48 hours. At which time the student must be placed with a host family with in that time period. Or the coordinator has canceled the hold within that time period. Or if the time period passes the hold is automatically canceled so that the next coordintor holding the student can have there chance to place the student with the Host Family. That is the key to the small project. In my current table schema the USER_ID represents the Coordinator. The STUDENT_ID represents the Student. There is no need to worry about Host Families at all. I hope this helps. Let me know if it makes more sense. Justin Palmer -----Original Message----- From: Peter Westergaard [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 12:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Hold System Could I get a plain-language explanation of the process of a 'hold'? I'm not entirely clear what is happening, and what an 'expiry' means in the context of the hold and what a '#1 position' would represent for a student. -P -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php