try
It may look pretty to use excessive whitespace, but generally it's only good in certain situations.PHP Code:<?php
if($logged['in'] === 0){
header("Location: index.php");
}
else {
$query = mysql_query("SELECT * FROM `private_messages` WHERE `pmto` = '$sess_username'");
$pm_count = mysql_num_rows($query);
$today = date("m.d.Y");
$yesterday - mktime(0, 0, 0, date('m') , date('d')-1, date('y'));
$read = mysql_query("SELECT `read` FROM `private_messages` WHERE `pmto` = '$sess_username'");
while ($display = mysql_fetch_array($query)){
if(!$pm_count){
echo 'You do not have any messages at this time.';
}
else {
$query1 = mysql_query("SELECT * FROM `private_messages` WHERE `date` = '$today' AND `pmto` = '$sess_username'") or die(mysql_error());
if(mysql_num_rows($query1) > 0) {
echo "<b>Today</b><br />";
while($display = mysql_fetch_array($query1)) {
if($read === 0) {
echo "<b>";
echo $display['title']." - ".$display['from'];
echo "</b>";
echo "<br />";
}
echo $display['title']." - ".$display['from'];
echo "<br />";
}
}
}
$query2 = mysql_query("SELECT * FROM `private_messages` WHERE `date` = '$yesterday' AND `pmto` = '$sess_username'") or die(mysql_error());
if(mysql_num_rows($query2) > 0) {
echo "<b>Yesterday</b><br />";
while($display1 = mysql_fetch_array($query2)) {
if(!$read) {
echo "<b>";
echo $display1['title']." - ".$display1['from'];
echo "</b>";
echo "<br />";
}
else {
echo $display1['title']." - ".$display1['from'];
echo "<br />";
}
}
}
$query3 = mysql_query("SELECT * FROM `private_messages` WHERE `date` != '$today' AND `date` != '$yesterday' AND `pmto` = '$sess_username'") or die(mysql_error());
while($display2 = mysql_fetch_array($query3)) {
if(!$read) {
echo "<b>";
echo $display2['title']." - ".$display2['from'];
echo "</b>";
echo "<br />";
}
else {
echo $display2['title']." - ".$display2['from'];
echo "<br />";
}
}
}
}
}
?>





lol.
Reply With Quote
