| Hits | Referrer | From To Date |
|---|---|---|
| '.$row["referrals"].' | '.$row["ad_ref_domain"].' | '.$row["mindate"].' '.$pdpmaxdate.' |
No Records Returned | ';}
?>
= '".$_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(); ?>
| Hits | Referrer | From To Date |
|---|---|---|
| '.$row["referrals"].' | '.$row["ad_ref_domain"].' | '.$row["mindate"].' '.$pdpmaxdate.' |
No Records Returned | ';}
?>