Idle Contact List Click [Manage] to View and Edit Contact.
|
|
Name
| Company
| Phone
| Email
| Manage
|
$listem = @mysql_query("SELECT ID,first_Name,Name,Company,Phone,email,dtnum,usrn FROM con_main WHERE usrn='none' ORDER BY Name");
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'];
$Phone = $row['Phone'];
$email = $row['email'];
$dtnum = $row['dtnum'];
$repusrn = $row['usrn'];
$checkem = @mysql_query("SELECT react_month FROM con_reactivity WHERE CID='$ID'");
if(!$checkem){
echo('Error Checking Activity.
' . 'Error: '. mysql_error(). '
');
}else{
$num_rows = mysql_num_rows($checkem);
if($num_rows < 1){
$act_flag = "
";
}else{
$act_flag = "
";
}
}
echo("$act_flag $first_Name $Name | $Company | $Phone | $email | " .
"[View/Edit] [DEL] [Reassign] |
");
}
?>
|