" " && $_REQUEST["del"] == "y" && $_REQUEST["replyid"] > " "){ $SelectStr = "select count(ID) as totalMsg from messages where Reply_ID = '" . $_REQUEST["replyid"] . "'"; $result = mysql_query($SelectStr) or die(mysql_error()); $myrow=mysql_fetch_array($result) ; $totalMsg = $myrow["totalMsg"] ; if($totalMsg > "1"){ $sqlupdate = "SELECT * FROM messages where ((From_ID = '" . $_SESSION["sessionUserID"] . "' and To_ID = '" . $_REQUEST["tom"] . "' and Shpw_Msg='N') or (To_ID = '" . $_SESSION["sessionUserID"] . "' and From_ID = '" . $_REQUEST["tom"] . "' and Shpw_Msg='N')) and Reply_ID = '" . $_REQUEST["replyid"] . "'"; $result2 = mysql_query($sqlupdate) or die(mysql_error()); $num_rows = mysql_num_rows($result2); if($num_rows > "0"){ $sqlupdate = " Delete from messages where Reply_ID = '" . $_REQUEST["replyid"] . "'"; $result2 = mysql_query($sqlupdate) or die(mysql_error()); $delete = "y" ; } else { $sqlupdate = "Update messages Set Shpw_Msg='N' where Reply_ID = '" . $_REQUEST["replyid"] . "' and To_ID ='" . $_SESSION["sessionUserID"] . "'"; $result2 = mysql_query($sqlupdate) or die(mysql_error()); $delete = "y" ; } } else { $sqlupdate = " Delete from messages where Reply_ID = '" . $_REQUEST["replyid"] . "'"; $result2 = mysql_query($sqlupdate) or die(mysql_error()); $delete = "y" ; } } if($_REQUEST["id"] > " " && $_REQUEST["red"] == "y"){ $sqlupdate = "Update messages Set Mark_As_Read='Y' where ID='$id' and To_ID ='" . $_SESSION["sessionUserID"] . "'"; $result2 = mysql_query($sqlupdate) or die(mysql_error()); } if($_REQUEST["id"] > " " && $_REQUEST["red"] == "n"){ $sqlupdate = " Update messages Set Mark_As_Read='N' where ID='$id' and To_ID ='" . $_SESSION["sessionUserID"] . "'"; $result2 = mysql_query($sqlupdate) or die(mysql_error()); } ?> Yada Home | Messages
yada home
my fridge

The message has been removed.


« Back to Inbox &del=y&tom=&replyid=" class="discussLinks6">Delete Message 0){ ?> | &rep=" class="discussLinks4">Reply

0 ) )) ORDER BY messages.TXN_TS DESC"; $resultMsg = mysql_query($SQL) or die(mysql_error()); while($myrowMsg=MySQL_fetch_array($resultMsg)){ $MID =$myrowMsg["MID"]; $Last_Name =ucfirst($myrowMsg["Last_Name"]); $First_Name =ucfirst($myrowMsg["First_Name"]); $The_Text =$myrowMsg["The_Text"]; $Date_Sent =$myrowMsg["newDate"]; $Time_Sent =$myrowMsg["newTime"]; $Mark_As_Read =$myrowMsg["Mark_As_Read"]; if($i =="3"){$i = 1;} ?>
>re: from You | RECEIVED ON AT
>

>

 
 
free profile