Contact List
(Ordered by )
|
Find...
New Contact
|
Name
|
| Phone
| Email
| Manage
|
$listem = @mysql_query("SELECT ID,first_Name,Name,Company,biztype,Phone,email,dtnum FROM con_main WHERE usrn='$usrn' 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'];
if($ob='biztype'){
$bizzy=$biztype;
}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 | " .
"[Manage] [DEL] |
");
}
?>
|