$SQL = "SELECT DATE_FORMAT(Date_Sent, '%M %d, %Y') as newDate,TIME_FORMAT(Time_Sent, '%l:%i %p') as newTime, messages.ID as MID,messages.* from messages where (To_ID = '" . $_SESSION["sessionUserID"] . "') and (Type = 'YADA_SYSTEM') ORDER BY messages.ID DESC";
$resultMsg = mysql_query($SQL) or die(mysql_error());
while($myrowMsg=MySQL_fetch_array($resultMsg)){
$MID =$myrowMsg["MID"];
$Display_Name = "YadaHome";
$The_Text =$myrowMsg["The_Text"];
$Date_Sent =$myrowMsg["newDate"];
$Time_Sent =$myrowMsg["newTime"];
$Mark_As_Read =$myrowMsg["Mark_As_Read"];
?>
if($Mark_As_Read == "Y"){?>from =$First_Name?> =$Last_Name?> } else {?>
from =$Display_Name?> }?>
if($Mark_As_Read == "Y"){?> =$The_Text?> } else {?> =$The_Text?> }?> |
|
=$Date_Sent?> at =$Time_Sent?> |
|
Mark as Read |
Mark as Unread |
Delete |
}?>
$SQL = "SELECT DATE_FORMAT(Date_Sent, '%M %d, %Y') as newDate,TIME_FORMAT(Time_Sent, '%l:%i %p') as newTime, messages.ID as MID,messages.*, Last_Name,First_Name,users.ID from messages,users where (To_ID = '" . $_SESSION["sessionUserID"] . "') and (users.ID = messages.From_ID) ORDER BY messages.ID 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($Mark_As_Read == "Y"){?>from =$First_Name?> =$Last_Name?> } else {?>
from =$First_Name?> =$Last_Name?> }?>
if($Mark_As_Read == "Y"){?> =$The_Text?> } else {?> =$The_Text?> }?> |
|
=$Date_Sent?> at =$Time_Sent?> |
|
Mark as Read |
Mark as Unread |
Delete |
}?> |
|
|