$dnum = date(Ymd)*4;
$from = $_GET['fr'];
if($from == ""){
$from = $_POST['fr'];
}
if($from != $dnum){
echo("<<<<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();
}
$searchby = $_POST['searchby'];
$input = $_POST['input'];
$repname1 = $_POST['repname1'];
$repname2 = $_POST['repname2'];
$today = date("F j, Y");
if($searchby == 'Name'){
$ob='Name';
$serby='Name';
}elseif($searchby == 'Company'){
$ob='Company';
$serby='Company';
}elseif($searchby == 'email'){
$ob='email';
$serby='email';
}elseif($searchby == 'City'){
$ob='City';
$serby='City';
}elseif($searchby == 'State'){
$ob='State';
$serby='State';
}elseif($searchby == 'ZipCode'){
$ob='Zip Code';
$serby='ZipCode';
}else{
$ob='Search Error';
$serby='';
}
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_contacts', $dbcnx);
?>
|
Eco-$mart, Inc. On-line Administration
|
Contacts Found
(Searched by )
|
Find...
New Contact
|
Name
| Company
| Phone
| Email
| Manage
|
$listem = @mysql_query("SELECT ID,Name,Company,Phone,email,dtnum FROM con_main WHERE usrn='$usrn' and $serby LIKE '%$input%' ORDER BY $serby");
if (!$listem) {
echo("Error retrieving data from data base. " . "Error: ". mysql_error(). " |
");
}
while ($row = mysql_fetch_array($listem)) {
$ID = $row['ID'];
$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('Error Checking Activity.
' . 'Error: '. mysql_error(). '
');
}else{
$rowb = mysql_fetch_row($checkem);
$check = $rowb[0];
if ($check != 0){
$act_flag = "
";
}else{
$act_flag = "
";
}
}
echo("$act_flag $Name | $Company | $Phone | $email | " .
"[Manage] [DEL] |
");
}
?>
|
©2007 - Data Base Interface - Custom Built at:
|