= '".$_POST["fromdate"]." 00:00:00'"; } } if(isset($_POST["todate"])) { $thetodate=$_POST["todate"]; if($_POST["todate"] != "") { $condc =" AND `bw_ad_referrer`.`thedate` <= '".$_POST["todate"]." 00:00:00'"; } } if(isset($_POST["search"])) { $conda=" AND `bw_ad_referrer`.`ad_referrer` like '%".$_POST["search"]."%' "; $searchterm=$_POST["search"]; } $sql="SELECT Count(`bw_ad_referrer`.`ad_ref_domain`) AS `referrals`, `bw_ad_referrer`.`ad_referrer`, `bw_ad_referrer`.`ad_ref_domain`, `bw_ad_referrer`.`thedate`, Max(`bw_ad_referrer`.`thedate`) AS `maxdate`, Min(`bw_ad_referrer`.`thedate`) AS `mindate` FROM `bw_ad_referrer` WHERE `bw_ad_referrer`.`ad_ref_domain` IS NOT NULL ".$conda.$condb.$condc." GROUP BY `bw_ad_referrer`.`ad_ref_domain` ORDER BY `referrals` DESC"; //echo $sql; $result= $database->database_query($sql) or $em=$em.$database->database_error(); ?> Ad Referrals

Ad Referrals

database_fetch_assoc($result)) { $rownum=$rownum+1; if($rownum % 2 != 0){$rc="#ffff99";} else{$rc="#fff";} if($row["referrals"]==1) { $pdpmaxdate=""; } else { $pdpmaxdate=$row["maxdate"]; } echo ''; } if($rownum==0){echo '';} ?>
Hits Referrer From To Date
'.$row["referrals"].' '.$row["ad_ref_domain"].' '.$row["mindate"].'
'.$pdpmaxdate.'

No Records Returned