| Ad Referrer | Ad Date | Signup Date | Userid |
|---|---|---|---|
| '.$row["ad_ref_domain"].' | '.$row["thedate"].' | '.$row["sign_up_date"].' | '.$row["su_uid"].' |
'.$rownum.' Records | |||
No Records Returned | |||
= '".$_POST["fromdate"]."'"; } } if(isset($_POST["todate"])) { $thetodate=$_POST["todate"]; if($_POST["todate"] != "") { $condc =" AND `bw_ad_referrer`.`thedate` <= '".$_POST["todate"]."'"; } } if(isset($_POST["search"])) { $conda=" AND `bw_ad_referrer`.`ad_referrer` like '%".$_POST["search"]."%' "; $searchterm=$_POST["search"]; } $sql="SELECT `bw_ad_referrer`.`refid`, `bw_ad_referrer`.`adref_ip`, `bw_ad_referrer`.`thedate`, `bw_ad_referrer`.`ad_referrer`, `bw_ad_referrer`.`ad_ref_domain`, `bw_ad_referrer`.`sign_up_date`, `bw_ad_referrer`.`su_uid`, `se_users`.`user_level_id`, `se_users`.`user_username`, `se_users`.`user_ip_lastactive` FROM `bw_ad_referrer` Left Outer Join `se_users` ON `se_users`.`user_ip_signup` = `bw_ad_referrer`.`adref_ip` WHERE `bw_ad_referrer`.`adref_ip` = `se_users`.`user_ip_signup` AND `bw_ad_referrer`.`su_uid` > 0 AND `bw_ad_referrer`.`ad_ref_domain` = '".$addomain."' GROUP BY `bw_ad_referrer`.`su_uid` ORDER BY `bw_ad_referrer`.`thedate` DESC, `se_users`.`user_level_id` ASC"; $result= $database->database_query($sql) or $em=$em.$database->database_error(); ?>
| Ad Referrer | Ad Date | Signup Date | Userid |
|---|---|---|---|
| '.$row["ad_ref_domain"].' | '.$row["thedate"].' | '.$row["sign_up_date"].' | '.$row["su_uid"].' |
'.$rownum.' Records | |||
No Records Returned | |||