'.$q; $qr = mysql_query($q) or die('Error: '.mysql_error()); ?> ='".date("Y-m-d",strtotime($_REQUEST['s_date_from']))."' and c_date<='".date("Y-m-d",strtotime("+1 days",strtotime($_REQUEST['s_date_to'])))."')"; $totalLeads = mysql_query($getTotalLeads); $leads = mysql_fetch_array($totalLeads); // get no of dhs converted $payments = array(); $s = "select b.code from customer_booking b,customer cc WHERE b.payment_status=2 and (b.c_date >='".date("Y-m-d",strtotime($_REQUEST['s_date_from']))."' and b.c_date<='".date("Y-m-d",strtotime("+1 days",strtotime($_REQUEST['s_date_to'])))."') and cc.sale_employee_code_new='".$emp['admin_id']."' and b.customer_code = cc.code "; //echo '
'.$s; $r = mysql_query($s); while($r2 = mysql_fetch_assoc($r)) { $policy_array[] = $r2['code']; $ss = "select * from view_policy_payments where policy_code = '".$r2['code']."' "; $rr = mysql_query($ss); $pay = mysql_fetch_assoc($rr); $payments[$pay['payments']]++; } /* echo '

';
				print_r($leads['total_leads']);
				echo '

'; */ ?> >

Sr. #	Emp Name	Branch	Date Range	Monthly Target	Total New Leads	Converted	Pending
			-to-	200	0 ? $leads['total_leads']: 0); ?>

Pagination Finish } break; }; } ?>