$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();
}
$id = $_GET['id'];
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_contacts', $dbcnx);
$listem = @mysql_query("SELECT name,biz_name,address_1,address_2,city,state,zip,country,phone,email,customer_type,specify,username,password,status FROM specialhome WHERE ID = '$id'");
if (!$listem) {
echo("Error retrieving data from data base.
" . 'Error: '. mysql_error(). '
');
}else{
$row = mysql_fetch_row($listem);
$stat1 = 'hold';
$stat2 = 'wholesale';
$call2 = 'special';
$stat3 = 'dealer';
$stat4 = 'distributor';
}
$chkit = mysql_query("SELECT email,usrn FROM con_main WHERE email='$row[9]'");
if(!$chkit){
$repmess = "Could not cross reference Representative Contact.";
}else{
$numrows = mysql_num_rows($chkit);
$reprow = mysql_fetch_array($chkit);
if($numrows > 0 and $reprow[1] != "none"){
$repmess = "
Rep: ".$reprow[1]."
";
}else{
$repmess = "Assign Contact
";
}
}//else
?>
|
Eco-$mart, Inc. On-line Administration
|
©2007 - Data Base Interface - Custom Built at:
|