RE: [PHP] Auto escalation

Hi, Actually, it sounds to me like he wants to escalate trouble tickets. I've done this before. Simply: 1. Make a cron that monitors the time, and when a ticket was last touched. 2. Base it on seconds, set it to automatically set the status to a certain level after so many seconds. 3. When some levels are hit, and you want more features, just simply code them. I had it e-mail the Ops Manager when it hit level 4 (48 hours of no touches). Lemme know if that doesn't help. -Dan Joseph -----Original Message----- From: John W. Holmes [mailto:holmes072000@charter.net] Sent: Tuesday, April 01, 2003 11:30 PM To: 'Praveen Kumar'; php-general@lists.php.net Subject: RE: [PHP] Auto escalation > Dear All, > I'm new to the list. I'm intended to use the auto escalation > functionality in my current project which is related to helpdesk. Can > you please give me some suggestions about how to develop this. I'm using > PHP, MySQL If I'm guessing correctly, you mean auto_increment. There are plenty of examples in the manual (it's a mysql feature, not PHP). Please start reading there and come back if you have a specific question about your project. You'll probably want to make use of the mysql_insert_id() function in PHP. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php