Edit Referrer Information
|
Help
|
$ID = $_GET['ID'];
$dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1');
mysql_select_db('ecosmar_contacts', $dbcnx);
$listem = @mysql_query("SELECT ID,name_1,name_2,Company,address,city,state,Country,ZipCode,phone,email,Link,track,status,pay,rate,product,req_by,dtnum FROM refcon WHERE ID='$ID'");
if (!$listem) {
echo("
Error getting Data 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'];
$Country = $row['Country'];
$ZipCode = $row['ZipCode'];
$phone = $row['phone'];
$email = $row['email'];
$Link = $row['Link'];
$trak = $row['track'];
$status = $row['status'];
if($status == 'Hold'){
$st1 = 'Hold';
$st2 = 'Active';
$st3 = 'Inactive';
}elseif($status == 'Inactive'){
$st1 = 'Inactive';
$st2 = 'Active';
$st3 = 'Hold';
}elseif($status == 'Active'){
$st1 = 'Active';
$st2 = 'Hold';
$st3 = 'Inactive';
}
$pay = $row['pay'];
$rate = $row['rate'];
$product = $row['product'];
$req_by = $row['req_by'];
$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];
if($product != "all"){
$getprodname = mysql_query("SELECT name FROM refprod WHERE TRI='$product'");
if(!$getprodname){
$prodmess = "
Registered Referrer for Product:".$product."
Could not get further information.";
}else{
$rowp = mysql_fetch_array($getprodname);
$productname = $rowp[0];
$prodmess = "
Registered Referrer for Product:".$productname;
}
}//referrer is not for all
else{
$prodmess = "
Registered Referrer for all Eco-\$mart Products.";
}
?>