New Agent Applications
|
Help
[Deny] will Remove Applicant from this list. Contact Remains.
|
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_contacts', $dbcnx);
$listem = @mysql_query("SELECT * FROM new_agent ORDER BY dtnum DESC");
if (!$listem) {
echo("
Error retrieving data from New Agent Applications. Error: ". mysql_error(). " |
");
}
$num_rows = mysql_num_rows($listem);
if($num_rows < 1){
echo("
There are No New Agent Applications |
");
}else{
while ($row = mysql_fetch_array($listem)) {
$ID = $row['ID'];
$Name_1 = $row['Name1'];
$Name_2 = $row['Name2'];
$Company = $row['Company'];
$Address = $row['Address'];
$City = $row['City'];
$State = $row['State'];
$ZipCode = $row['ZipCode'];
$Country = $row['Country'];
$Phone = $row['phone'];
$email = $row['email'];
$Link = $row['Link'];
$Interests = $row['Interests'];
$Why = $row['Why'];
$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("
" .
"Applied On-line on $datus" .
" |
Set " .
" Deny " .
" | $Name_1 $Name_2" .
" | $Address $City, $State $ZipCode $Country" .
" | Phone: $Phone Email: $email Domain: $Link" .
" |
" .
" | Interests: $Interests" .
" |
" .
" | Why: $Why" .
" |
");
}
}
?>