Delete this Agent Profile?
|
Help
|
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_contacts', $dbcnx);
$listem = @mysql_query("SELECT ID,Name1,Name2,Company,Address,City,State,ZipCode,Country,Phone,email,Link,status,pay,rate,ref,dtnum FROM agent WHERE ID='$ID'");
if (!$listem) {
echo("
Error getting Application from Data Base.
" . 'Error: '. mysql_error(). '
');
}
$row = mysql_fetch_array($listem);
$ID = $row['ID'];
$Name_1 = $row['Name_1'];
$Name_2 = $row['Name_2'];
$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'];
$status = $row['status'];
$pay = $row['pay'];
$rate = $row['rate'];
$rate1 = sprintf("%01.2f", $rate);
$ref = $row['ref'];
$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];
?>