| All Regional Contact List
(Ordered by )
|
Help
|
| Name
|
| Phone
| Email
| Manage
|
$first_name_array[$i] $last_name_array[$i] | ");
$listem = @mysql_query("SELECT ID,first_Name,Name,Company,biztype,Phone,email,dtnum,usrn FROM con_main WHERE usrn='$bean' ORDER BY $ordby $dir");
if (!$listem) {
die('Error geting list from conmain.
' . 'Error: '. mysql_error(). '
');
}
while ($row = mysql_fetch_array($listem)) {
$ID = $row['ID'];
$first_Name = $row['first_Name'];
$Name = $row['Name'];
$Company = $row['Company'];
$biztype = $row['biztype'];
$Phone = $row['Phone'];
$email = $row['email'];
$dtnum = $row['dtnum'];
$repusrn = $row['usrn'];
if($ob=='Company'){
$bizzy = $Company;
}elseif($ob=='Business Type'){
$bizzy = $biztype;
}
$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 $first_Name $Name | $bizzy | $Phone | $email | " .
"[View/Note] [RE-ASSIGN] |
");
}
$i++;
}
?>
| |
