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:[EMAIL PROTECTED] 
Sent: Tuesday, April 01, 2003 11:30 PM
To: 'Praveen Kumar'; [EMAIL PROTECTED]
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


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

Reply via email to