<<<<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(); } $listrep = $_POST['listrep']; if($listrep == ""){ $listrep = $_GET['listrep']; } $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_website', $dbcnx); $passem = @mysql_query("SELECT ID,pswcon FROM psw WHERE usrn='$usrn'"); if (!$passem) { die("

Error Checking Password.
" . "Error: " . mysql_error(). "

"); } $row = mysql_fetch_array($passem); $pswcon = $row[1]; if($pswcon != 'All'){ echo("

<<<<Restricted Area>>>>" . "
Sorry, you must have clearance to view All Contacts

"); exit(); }else{ $getem = @mysql_query("SELECT ID,first_name,last_name,pswcon FROM psw WHERE usrn='$listrep'"); if (!$getem) { die("

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

"); } $row2 = mysql_fetch_array($getem); $first_name = $row2[1]; $last_name = $row2[2]; $status = $row2[3]; } $order = $_POST['order']; $ssss = $_POST['ssss']; if($order == ""){ $order = "Name"; } if($ssss == ""){ $ssss = "ASC"; } ?>
Contacts Eco-$mart, Inc.  On-line Administration
'); } $num_rows = mysql_num_rows($listem); if($num_rows < 1){ echo(""); }else{ $color_check = 1; while ($row = mysql_fetch_array($listem)) { $ID = $row['ID']; $first_Name = $row['first_Name']; $Name = $row['Name']; $Company = $row['Company']; $Phone = $row['Phone']; $email = $row['email']; $dtnum = $row['dtnum']; $checkem = @mysql_query("SELECT react_month FROM con_reactivity WHERE CID='$ID'"); if(!$checkem){ echo(''); } $rowb = mysql_fetch_row($checkem); $check = $rowb[0]; if ($check != 0){ $act_flag = ""; }else{ $act_flag = ""; } $whether = $color_check / 2; if(is_int($whether)){ $bgc = "#F1FFF1"; }else{ $bgc = "#CDFFCD"; } echo("" . "" . ""); $color_check = $color_check + 1; }//while }//else ?>
 Contact List for   SORT BY = Sort By   CHANGE ORDER = Change Order  Re-assign List   Help 
 Manage
" . "" . "" . "" . "" . "" . "" . ""); }elseif($ssss == "DESC"){ echo("
" . "" . "" . "" . "" . "" . "" . "
"); } }else{ echo("
" . "" . "" . "" . "" . "" . "" . "
"); } ?>
Name
" . "" . "" . "" . "" . "" . "" . ""); }elseif($ssss == "DESC"){ echo("
" . "" . "" . "" . "" . "" . "" . "
"); } }else{ echo("
" . "" . "" . "" . "" . "" . "" . "
"); } ?>
Company
" . "" . "" . "" . "" . "" . "" . ""); }elseif($ssss == "DESC"){ echo("
" . "" . "" . "" . "" . "" . "" . "
"); } }else{ echo("
" . "" . "" . "" . "" . "" . "" . "
"); } ?>
Phone
" . "" . "" . "" . "" . "" . "" . ""); }elseif($ssss == "DESC"){ echo("
" . "" . "" . "" . "" . "" . "" . "
"); } }else{ echo("
" . "" . "" . "" . "" . "" . "" . "
"); } ?>
Email
Error retrieving data from data base.
' . 'Error: '. mysql_error(). '
There are No Contacts for this Representative
Error Checking Activity.
' . 'Error: '. mysql_error(). '
[ View/Edit ]" . "  [ RE-ASSIGN ]" . "  [ DEL ] $act_flag $first_Name $Name$Company $Phone$email
 
 BACK   Your Contacts   All Contacts   Return to Your Page 
Eco-$mart Products
©2007 - Data Base Interface - Custom Built at:  kwgrubbs.com