$dbcnx = @mysql_connect('mysql.plainhost.com','ecosmar_ecosmart','ecoman1');
mysql_select_db('ecosmar_friendly', $dbcnx);
$listem = @mysql_query("SELECT ID,MID,fr_name,subject,message,dtnum FROM messages WHERE ID='$ID'");
if (!$listem) {
echo("Problem retrieving Messages.
Error: ". mysql_error());
exit();
}
$row = mysql_fetch_row($listem);
$ID = $row[0];
$MID = $row[1];
$fr_name = $row[2];
$fr_chunk = explode(" ", $fr_name);
$first_name = $fr_chunk[0];
$last_name = $fr_chunk[1];
$contact = "11:".$first_name.":".$last_name.":".$fr_name;
$subject = $row[3];
$message = $row[4];
$input = nl2br($message);
$input2 = stripslashes($input);
$mdtnum = $row[5];
$chunk_dtnum = chunk_split($mdtnum, 2, ':');
$chunk_arr = explode(":", $chunk_dtnum);
?>
Subject:
Reply Message:
Message will be signed and dated when you click "Send".
To This Message:
if($MID == 0){
$listemb = @mysql_query("SELECT fr_name,message,dtnum FROM messages WHERE MID='$ID' ORDER BY dtnum");
if (!$listemb) {
echo("Problem retrieving Replies. Error: ". mysql_error());
}
$num_rows = mysql_num_rows($listemb);
if($num_rows == 0 or $num_rows == ""){
echo("No Replies ");
}else{
while($row = mysql_fetch_array($listemb)){
$from = $row[0];
$message2 = $row[1];
$input = nl2br($message2);
$input2 = stripslashes($input);
$mdtnum2 = $row[2];
$chunk_dtnum2 = chunk_split($mdtnum2, 2, ':');
$chunk_arr2 = explode(":", $chunk_dtnum2);
echo("$chunk_arr2[2]/$chunk_arr2[3]/$chunk_arr2[0]$chunk_arr2[1] ---------- " .
"From: $from " .
"$input2 ");
}
}
}else{
$listema = @mysql_query("SELECT fr_name,message,dtnum FROM messages WHERE ID='$MID'");
if (!$listema) {
echo("Problem retrieving Original Message. Error: ". mysql_error());
}
$rowa = mysql_fetch_array($listema);
$froma = $rowa[0];
$message2a = $rowa[1];
$inputa = nl2br($message2a);
$input2a = stripslashes($inputa);
$mdtnum1 = $rowa[2];
$chunk_dtnum1 = chunk_split($mdtnum1, 2, ':');
$chunk_arr2a = explode(":", $chunk_dtnum1);
echo("Original Message: $chunk_arr2a[2]/$chunk_arr2a[3]/$chunk_arr2a[0]$chunk_arr2a[1] " .
"From: $froma " .
"$input2a ");
$listemb = @mysql_query("SELECT fr_name,message,dtnum FROM messages WHERE MID='$MID' AND ID !='$ID' ORDER BY dtnum");
if (!$listemb) {
echo("Problem retrieving Replies. Error: ". mysql_error());
}
$num_rows = mysql_num_rows($listemb);
if($num_rows == 0 or $num_rows == ""){
echo("No Replies ");
}else{
while($row = mysql_fetch_array($listemb)){
$from = $row[0];
$message2 = $row[1];
$input = nl2br($message2);
$input2 = stripslashes($input);
$mdtnum2 = $row[2];
$chunk_dtnum2 = chunk_split($mdtnum2, 2, ':');
$chunk_arr2 = explode(":", $chunk_dtnum2);
echo("$chunk_arr2[2]/$chunk_arr2[3]/$chunk_arr2[0]$chunk_arr2[1] ---------- " .
"From: $from " .
"$input2 ");
}
}
}
?>
[Back to Messages]