$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['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'];
$status = $row['status'];
if($status == 'Hold'){
$st_op1 = 'Hold';
$st_op2 = 'Active';
$st_op3 = 'Inactive';
}elseif($status == 'Active'){
$st_op1 = 'Active';
$st_op2 = 'Hold';
$st_op3 = 'Inactive';
}elseif($status == 'Inactive'){
$st_op1 = 'Inactive';
$st_op2 = 'Hold';
$st_op3 = 'Active';
}
$pay = $row['pay'];
if($pay == 'flat'){
$rad1 = "CHECKED";
}else{
$rad1 = "";
}
if($pay == 'percent'){
$rad2 = "CHECKED";
}else{
$rad2 = "";
}
if($pay == 'no'){
$rad3 = "CHECKED";
}else{
$rad3 = "";
}
$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];
?>
Edit Agent Profile
Last Update:
|
Help
|
echo("