RE: [PHP] Auto escalation

2003-04-01 Thread John W. Holmes
 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



RE: [PHP] Auto escalation

2003-04-01 Thread Dan Joseph
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