<<<<Restricted Area>>>>" . "
Sorry, you must Log In to view this Page

"); exit(); } $usrn = $_GET['usrn']; if($usrn == ""){ $usrn = $_POST['usrn']; } if($usrn == ""){ echo("

<<<<Restricted Area>>>>" . "
Problem with your username. Please Log In again.

"); exit(); } $airs=array(); $refcombo=$_POST['referrer']; $refblo=explode(':', $refcombo); $Ref_ID=$refblo[0]; $Ref_name=$refblo[1]; $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_website', $dbcnx); $getcount = mysql_query("SELECT count FROM webtrack WHERE RID='$Ref_ID'"); if(!$getcount){ $airs[]="Could not get count for webtrack."; //echo mysql_error(); }else{//got count $rowc = mysql_fetch_array($getcount); $visits = $rowc[0]; }//got count mysql_select_db('ecosmar_contacts', $dbcnx); $listem = @mysql_query("SELECT ID,Contact_Type,Product,Name,Company,biztype,City,State,ZipCode,Phone,email,ref_RID,Project_Type,Project_Description,dtnum FROM webcontacts WHERE ref_RID='$Ref_ID' ORDER BY dtnum DESC"); if (!$listem) { echo("
Error retrieving data from data base.
" . "Error: ". mysql_error(). "
"); exit(); } $num_rows = mysql_num_rows($listem); ?>
Contacts

Eco-$mart, Inc.  On-line Administration

 Web Contacts Referred By:   Referrals from  visits.  Help 
There are No Web Contacts For $Ref_name"); }else{ while ($row = mysql_fetch_array($listem)) { $ID = $row['ID']; $Contact_Type = $row['Contact_Type']; $Product = $row['Product']; $Name = $row['Name']; $Company = $row['Company']; $biztype = $row['biztype']; $City = $row['City']; $State = $row['State']; $ZipCode = $row['ZipCode']; $Phone = $row['Phone']; $email = $row['email']; $ref_RID = $row['ref_RID']; $Project_Type = $row['Project_Type']; if($Project_Type == ""){ $proj = " "; }else{ $proj = "Project Type: $Project_Type"; } $Project_Description = $row['Project_Description']; if($Project_Description == ""){ $projd = " "; }else{ $Project_Des = htmlspecialchars($Project_Description); $projd = "Description: $Project_Des"; } $dtnum = $row['dtnum']; $chunk_dtnum = chunk_split($dtnum, 2, ':'); $chunk_arr = explode(":", $chunk_dtnum); $datus = $chunk_arr[2].'-'.$chunk_arr[3].'-'.$chunk_arr[0].$chunk_arr[1]; echo("" . "" . "" . "" . "
Contact Date: $datusContact Type: $Contact_TypeProduct: $Product
" . "" . "" . "
[Assign]" . "  [DEL]" . "$Name, $Company" . "
$City, $State $ZipCode" . "
Phone: $Phone
Email: $email
Business Type: $biztype
" . "
$proj
$projd" . "
"); } } ?>  
 Web Contacts   Your Contacts   All Contacts   Return to Your Page 
Eco-$mart Products
©2011 - Data Base Interface - Custom Built at:  kwgrubbs.com