Displaying 1 result from an estimated 1 matches for "query_duration".
2009 Dec 14
1
AGI with PHP
...$mysql_host = 'localhost';
$mysql_user = 'username';
$mysql_password = 'password';
$my_database = 'asteriskcdr';
$dbtable = 'cdr';
$from_date = '20091205000000';
$to_date = '20100104235959';
$callnum = '0';
$minutes = '0';
$query_duration = "SELECT SUM(billsec) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%'";
$query_calls = "SELECT COUNT(dst) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition...