<<<<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(); } $ID = $_GET['ID']; $repusrn = $_GET['repusrn']; $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 FROM psw WHERE usrn='$repusrn'"); if (!$ok) { echo 'Could not retrieve Rep Name: ' . mysql_error(); exit; } $rowa = mysql_fetch_array($ok); $repname1 = $rowa[0]; $repname2 = $rowa[1]; ?>
Contacts Eco-$mart, Inc.  On-line Administration
Error retrieving data from data base.
' . 'Error: '. mysql_error(). '

'); } $row = mysql_fetch_array($listem); $ID = $row['ID']; $first_Name = $row['first_Name']; $Name = $row['Name']; $Title = $row['Title']; $Company = $row['Company']; $biztype = $row['biztype']; $Phone = $row['Phone']; $Address = $row['Address']; $FAX = $row['FAX']; $City = $row['City']; $email = $row['email']; $mkt = $row['mkt']; $State = $row['State']; $ZipCode = $row['ZipCode']; $dtnum = $row['dtnum']; $repusrn = $row['usrn']; $usremail = $row['usremail']; $referred_by = $row['referred_by']; $referee = explode(':', $referred_by); $referrer = $referee[1]; $ref_name = $referee[2]; if($mkt == 1){ $mktw = 'Yes'; $mktc = 'checked'; }else{ $mktw = 'No'; $mktc = ''; } ?>
Contact for   ~ ~
First Name: Title:
Last Name: Business Type:
Company: Phone:
Address: FAX:
City: Email:
State:     Zip:  Domain:
    Referred by:
Change =>
"); }else{ echo ("$ref_name
"); } $ok3 = @mysql_query("SELECT ID,name_1,name_2,Company FROM refcon ORDER BY name_2"); if (!$ok3) { echo 'Could not get Referrer List: ' . mysql_error(); }else{ echo(""); ?>

Alternate Contact:
Name:    Title:    Email: 

New Notes:
Notes are dated automatically.
 List for Email Marketing Program

Activity Report

Error retrieving data from data base.
' . 'Error: '. mysql_error(). '

'); } while($rowb = mysql_fetch_array($listemb)){ $act_ID = $rowb[0]; $act_y = $rowb[1]; $act_m = $rowb[2]; $act_d = $rowb[3]; $act_type = $rowb[4]; $act_resp = $rowb[5]; $dateup = $dtnum[6]; echo("

~ $act_m-$act_d-$act_y : $act_type : $act_resp

"); } $listemc = @mysql_query("SELECT ID,CID,react_year,react_month,react_day FROM con_reactivity WHERE CID='$ID'"); if (!$listemc) { echo('

Error retrieving data from data base.
' . 'Error: '. mysql_error(). '

'); } $num_rows = mysql_num_rows($listemc); if($num_rows < 1){ $act_flag = ""; }else{ $act_flag = ""; $rowc = mysql_fetch_row($listemc); $RID = $rowc[0]; $CID = $rowc[1]; $ract_y = $rowc[2]; $ract_m = $rowc[3]; $ract_d = $rowc[4]; if($ract_y == 0){ $ract = 'ASAP'; }else{ $ract = $ract_m.'-'.$ract_d.'-'.$ract_y; } echo("

$act_flag~ $ract   " . "Deactivate" . "

"); } ?>

Follow-up Report
  Date:       
  Type:  Visit   Phone   Email
  Response:  +Pos   ~NC   -Neg

Set RE-Contact Date (OPT)
  Date:       

       
Notes:
Error retrieving Notes from data base.
' . 'Error: '. mysql_error(). '

'); } while($rowc = mysql_fetch_array($listemc)){ $CID = $rowc[0]; $Notes = stripslashes($rowc[1]); $dtnum = $rowc[2]; $chunk_dtnum = chunk_split($dtnum, 2, ":"); $chunk_arr = explode(":", $chunk_dtnum); echo("

$chunk_arr[2]-$chunk_arr[3]-$chunk_arr[0]$chunk_arr[1] - $Notes

"); } ?>
Problem getting Mfg. Register". mysql_error(); }else{ $num_rows = mysql_num_rows($ok4); if($num_rows < 1){ echo ("This Contact has not been registered with any Manufacturers."); }else{ echo ("This Contact has been registered with Manufacturers: "); } while($row4 = mysql_fetch_array($ok4)){ $thisID = $row4['ID']; $thisCID = $row4['CID']; $regarray[] = $row4['MID']; } $i = 0; $mfgcount = count($regarray); while($i < $mfgcount){ $ok5 = @mysql_query("SELECT ID,prod_name FROM mfg WHERE ID='$regarray[$i]'"); if(!$ok5){ echo "Problem getting Mfg. Register". mysql_error(); }else{ $row5 = mysql_fetch_array($ok5); $nameo = $row5[1]; echo ("
$nameo "); } $i = $i+1; } } ?>

Contact Options
• Register Contact with Manufacturer
• Register Contact as an Eco-$mart Dealer
• Request Referral Payments TO THIS CONTACT

 Your Contacts   All Contacts   Return to Your Page 
Eco-$mart Products
©2007 - Data Base Interface - Custom Built at:  kwgrubbs.com