= '".$_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 Referrals

Ad Referrals

database_fetch_assoc($result)) { $rownum=$rownum+1; if($rownum % 2 != 0){$rc="#ffff99";} else{$rc="#fff";} echo ''; } if($rownum > 0) {echo '';} if($rownum==0){echo '';} ?>
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