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

"); exit(); } $usrn = $_GET['usrn']; $today = date("F j, Y"); $year = date(Y); $dtnum = date(Ymd); $y02 = $year - 2; $y01 = $year - 1; $y1 = $year + 1; $y2 = $year + 2; $y3 = $year + 3; $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_website', $dbcnx); $ok = @mysql_query("SELECT first_name,last_name,usrn,email,pswcon FROM psw WHERE usrn='$usrn'"); if (!$ok) { echo 'Could not run query: ' . mysql_error(); exit; } $row = mysql_fetch_array($ok); $repname1 = $row[0]; $repname2 = $row[1]; $usrn = $row[2]; $usremail = $row[3]; $pswcon = $row[4]; ?>
Click Here to Return

Eco-$mart Contacts
New Contact

New Contact for   ~ ~
*First Name: Title:
*Last Name: *Business Type:
Company: *Phone:
*Address: FAX:
City: *Email:
State:            *Zip:  Referred by: " . ""); } while($row2 = mysql_fetch_array($ok2)){ $name_1 = $row2['name_1']; $name_2 = $row2['name_2']; $name = $name_1.' '.$name_2; echo(""); } mysql_select_db('ecosmar_contacts', $dbcnx); $ok3 = @mysql_query("SELECT name_1,name_2 FROM refcon ORDER BY name_2"); if (!$ok3) { echo '
Could not get Referral List: ' . mysql_error(); }else{ while($row3 = mysql_fetch_array($ok3)){ $name_1 = $row3['name_1']; $name_2 = $row3['name_2']; $name = $name_1.' '.$name_2; echo(""); } } ?>
Notes: Notes are dated automatically.
 Add this Contact to Referrer List
 List for Email Marketing Program

Activity Report

First Contact
  Date:       
 Type: Visit  Phone  Email  Mail
  Response:  +Pos   ~NC   -Neg

Set RE-Contact Date (OPT)
  Date:       

*Required
   
 Your Contacts   New Contact  Search Your Contacts
Get CSV Help  Return to Your Page 
Eco-$mart Products
©2006 - Data Base Interface - Custom Built at:  kwgrubbs.com