Actually, the query I originally sent is probably OK...it is this query that may be causing the problem.... (I have left the PHP code intact.)
$qin = "SELECT COUNT(cdr.ani) AS qtyin, SUM(cdr.calldur/60) AS minin "; $qin .= "FROM tblCDR cdr LEFT OUTER JOIN CDRFilter e "; $qin .= "ON cdr.dialedno = e.phoneNumber "; $qin .= "WHERE e.phoneNumber IS NULL "; $qin .= "AND (cdr.dialedno LIKE '800%' "; $qin .= "OR cdr.dialedno LIKE '866%' "; $qin .= "OR cdr.dialedno LIKE '877%' "; $qin .= "OR cdr.dialedno LIKE '888%') "; $qin .= "AND cdr.pindigs = '' "; $qin .= "AND cdr.predig <> '2' "; $qin .= "AND cdr.predig <> '3' "; $qin .= "AND cdr.discn_dt <= '" . $cdrdate . "' "; $qin .= "AND cdr.billed_flag = '' "; Thanks! Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
