Not usre how your db is designed but I would probably just add a table that links to the sitter and job tables. As people are called a row is put into this table with the sitter and job ids and an 'accepted' column is set to 0, or 1 or Y or N. Then you can query the job table and join the sitter and this new table to get all the info you need.
Eddie -----Original Message----- From: Sarah Heffron [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 1:33 PM To: php list Subject: [PHP] Suggestions on how I should handle this I have an application I've written for a pet sitting service. So someone calls and says they need a pet sit and we take their info and pick a sitter. We call that sitter to see if they can take the job, but if they say no, then we have to change it to a new sitter who can take the job. I want to keep track of who says yes and who says no and make sure we know who the active sitter is for each job. Does anyone have suggestions of a good way to handle this with the database and such? Any thoughts appreciated, Sarah -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
