PHP - zprávy

<?php
//We check if the user is logged
if(isset($_SESSION['user']))
{
//We list his messages in a table
//Two queries are executes, one for the unread messages and another for read messages
$req1 = mysql_query('select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, users.id as userid, users.nick from pm as m1, pm as m2,users where ((m1.user1="'.$_SESSION['user'].'" and m1.user1read="no" and users.id=m1.user2) or (m1.user2="'.$_SESSION['user'].'" and m1.user2read="no" and users.id=m1.user1)) and m1.id2="1" and m2.id=m1.id group by m1.id order by m1.id desc');
$req2 = mysql_query('select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, users.id as userid, users.nick from pm as m1, pm as m2,users where ((m1.user1="'.$_SESSION['user'].'" and m1.user1read="yes" and users.id=m1.user2) or (m1.user2="'.$_SESSION['user'].'" and m1.user2read="yes" and users.id=m1.user1)) and m1.id2="1" and m2.id=m1.id group by m1.id order by m1.id desc');
?>
<br />
<a href="nova_zprava.php"><img src="img/pm.png"></img></a><br />
<h3>PŘIJATÉ (<?php echo intval(mysql_num_rows($req1)); ?>):</h3>
<table class="table table-striped">
    <tr>
        <th style="padding-left:25px">Odesilatel</th>
                    <th style="padding-left:25px">Předmět</th>                                                 
                    <th style="padding-left:25px">Odpovědí</th>
                    <th style="padding-left:25px">Čas odeslání</th>
                    <th style="padding-left:25px">Stav</th>    
    </tr>
<?php
//We display the list of unread messages
while($dn1 = mysql_fetch_array($req1))
{
?>
    <tr>
        <td class='first'><a href="/profile/<?php echo $dn1['nick']; ?>"><?php echo htmlentities($dn1['nick'], ENT_QUOTES, 'UTF-8'); ?></td>
        <td class="left"><a href="precist_zpravu.php?id=<?php echo $dn1['id']; ?>"><?php echo htmlentities($dn1['title'], ENT_QUOTES, 'UTF-8'); ?></a></td>
        <td><?php echo $dn1['reps']-1; ?></td>
        <td><?php echo date('d.m.Y v H:i' ,$dn1['timestamp']); ?></td>
        <td><?php if($dn1['user2read'] == "no"){echo'<img title="Tuto zprávu ještě nemáte přečtenou..." src="../img/red.png">';}elseif($dn1['user2read'] == "yes"){echo'<img title="Tuto zprávu již přečtenou máte..." src="../img/green.png">';}?></td>
    </tr>
<?php
}
//If there is no unread message we notice it
if(intval(mysql_num_rows($req1))==0)
{
?>
    <tr>
        <td colspan="4" class="center">Nemáš žádné nepřečtené zprávy.</td>
    </tr>
<?php
}
?>
</table>
<br />
<h3>ODESLANÉ (<?php echo intval(mysql_num_rows($req2)); ?>):</h3>
<table class="table table-striped">
    <tr>
        <th style="padding-left:25px">Přijemce</th>
                    <th style="padding-left:25px">Předmět</th>
                    <th style="padding-left:25px">Odpovědí</th>
                    <th style="padding-left:25px">Čas odeslání</th>
                    <th style="padding-left:25px">Stav</th> 
    </tr>
<?php
//We display the list of read messages
while($dn2 = mysql_fetch_array($req2))
{
?>
    <tr>
        <td class='first'><a href="/profile/<?php echo $dn2['nick']; ?>"><?php echo htmlentities($dn2['nick'], ENT_QUOTES, 'UTF-8'); ?></td>
        <td class="left"><a href="precist_zpravu.php?id=<?php echo $dn2['id']; ?>"><?php echo htmlentities($dn2['title'], ENT_QUOTES, 'UTF-8'); ?></a></td>
        <td><?php echo $dn2['reps']-1; ?></td>
        <td><?php echo date('d.m.Y v H:i' ,$dn2['timestamp']); ?></td>
        <td><?php if(
            $dn2['user2read'] == "no"){
            echo'<img title="Uživatel si zprávu ještě nepřečetl..." src="/img/red.png">';}
            else 
            if($dn2['user2read'] == "yes"){
            echo'<img title="Uživatel si zprávu přečetl..." src="/img/green.png">';
            };?></td>
    </tr>
<?php
}
//If there is no read message we notice it
if(intval(mysql_num_rows($req2))==0)
{
?>
    <tr>
        <td colspan="4" class="center">Nemáš žádné přečtené zprávy.</td>
    </tr>
<?php
}
?>
</table>
<?php
}
else
{
    echo 'You must be logged to access this page.';
}
?>