<<<<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'];
$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 retrieving data from data base.
" . "Error: " . mysql_error(). "
");
}
$row = mysql_fetch_array($passem);
$pswcon = $row[1];
if($pswcon != 'RD' and $pswcon != 'All' ){
echo("<<<<Restricted Area>>>>" .
"
Sorry, you must have clearance to view Regional 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];
}
?>
|
Eco-$mart, Inc. On-line Administration
|
| Regional Contact List for Click [View/Note] to View or Make Notes.
|
Help
|
| Name
| Company
| Phone
| Email
| Manage
|
Error retrieving data from data base.
' . 'Error: '. mysql_error(). ' | ');
}
$num_rows = mysql_num_rows($listem);
if($num_rows < 1){
echo("| There are No Contacts for this Representative |
");
}else{
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'];
$repusrn = $row['usrn'];
$checkem = @mysql_query("SELECT react_month FROM con_reactivity WHERE CID='$ID'");
if(!$checkem){
echo('Error Checking Activity.
' . 'Error: '. mysql_error(). ' |
');
}
$rowb = mysql_fetch_row($checkem);
$check = $rowb[0];
if ($check != 0){
$act_flag = "
";
}else{
$act_flag = "
";
}
echo("| $act_flag $first_Name $Name | $Company | $Phone | $email | " .
"[View/Note] [RE-ASSIGN] |
");
}
}
?>
| |
©2007 - Data Base Interface - Custom Built at:
|
