New Web ContactsClick [Assign] to Assign or Edit, or [DEL] to remove the Contact Completely.
|
Help
|
$listem = @mysql_query("SELECT ID,Contact_Type,Product,Name,Company,biztype,City,State,ZipCode,Phone,email,ref_RID,Project_Type,Project_Description,dtnum FROM webcontacts ORDER BY dtnum DESC");
if (!$listem) {
die("
Error retrieving data from data base. " . "Error: ". mysql_error(). " |
");
}
$num_rows = mysql_num_rows($listem);
if($num_rows < 1){
echo("
There are No New Web Contacts |
");
}else{
while ($row = mysql_fetch_array($listem)) {
$ID = $row['ID'];
$Contact_Type = $row['Contact_Type'];
$Product = $row['Product'];
$Name = $row['Name'];
$Company = $row['Company'];
$biztype = $row['biztype'];
$City = $row['City'];
$State = $row['State'];
$ZipCode = $row['ZipCode'];
$Phone = $row['Phone'];
$email = $row['email'];
$ref_RID = $row['ref_RID'];
$Project_Type = $row['Project_Type'];
if($Project_Type == ""){
$proj = " ";
}else{
$proj = "
Project Type: $Project_Type";
}
$Project_Description = $row['Project_Description'];
if($Project_Description == ""){
$projd = " ";
}else{
$Project_Des = htmlspecialchars($Project_Description);
$projd = "
Description: $Project_Des";
}
$dtnum = $row['dtnum'];
$chunk_dtnum = chunk_split($dtnum, 2, ':');
$chunk_arr = explode(":", $chunk_dtnum);
$datus = $chunk_arr[2].'-'.$chunk_arr[3].'-'.$chunk_arr[0].$chunk_arr[1];
echo("
" .
"Contact Date: $datus | " .
"Contact Type: $Contact_Type | " .
"Product: $Product |
" .
"
" .
"[Assign]" .
" [DEL]" .
" | $Name, $Company" .
" $City, $State $ZipCode" .
" | Phone: $Phone Email: $email | " .
"Business Type: $biztype Referrer ID: $ref_RID | " .
"
");
}
}
?>
|