All Contacts List
(Ordered by )
|
Help
|
Name
|
| Phone
| Email
| Manage
|
$listem = @mysql_query("SELECT ID,first_Name,Name,Company,biztype,Phone,email,dtnum,usrn FROM con_main ORDER BY $ordby $dir");
if (!$listem) {
die('Error retrieving data from data base.
' . '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 == 'biztype'){
$bizzy = $biztype;
}elseif($ob == 'Representative'){
$bizzy = $repusrn;
}else{
$bizzy = $Company;
}
$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] [RE-ASSIGN] [DEL] |
");
}
?>
|