Obrobrio

<table id='chats'>
                                <?php
                                    $query="SELECT  friendID AS chatID,
                                                    FU.nickname AS chatName,
                                                    FU.image_url AS chatImage,
                                                    mess_text,
                                                    date_time,
                                                    'user' AS chat_type
                                                FROM Friends F
                                                    JOIN Users U
                                                        ON F.userID=U.userID
                                                    LEFT JOIN Users FU
                                                        ON FU.userID=friendID
                                                    LEFT JOIN Messages M
                                                        ON F.last_message=M.messageID
                                                WHERE U.userID='$_SESSION[name]'
                                            UNION
                                            SELECT  G.groupID AS chatID,
                                                    group_name AS chatName,
                                                    G.image_url AS chatImage,
                                                    mess_text,
                                                    date_time,
                                                    'group' AS chat_type
                                                FROM Groups_users GU
                                                    JOIN Users U
                                                        ON GU.userID=U.userID
                                                    LEFT JOIN Groups G
                                                        ON GU.groupID=G.groupID
                                                    LEFT JOIN Messages M
                                                        ON G.last_message=M.messageID
                                                WHERE U.userID='$_SESSION[name]'
                                            ORDER BY date_time DESC;";
                                    $result=$db->query($query)->fetchAll();
                                        foreach($result as $row){
                                            if($row['chat_type']=='user')
                                                $chat_type='userID';
                                            else
                                                $chat_type='groupID';
                                            $chatID=$row['chatID'];
                                            $chatName=$row['chatName'];
                                            $chatImage="src/profile_pictures/".$row['chatImage'];
                                            $mess_text='Start a conversation';
                                            if(isset($row['mess_text'])){
                                                $mess_text=htmlspecialchars($row['mess_text']);
                                            }
                                            $date_time='';
                                            if(isset($row['date_time'])){
                                                $date_time=$row['date_time'];
                                                $date_time=date('H:i', strtotime($date_time));
                                            }
                                            echo "<tr><td class='select_chat'>
                                                    <a class='select_chat'
                                                    href='$_SERVER[PHP_SELF]?$chat_type=$chatID'>
                                                        <div class='select_chat'>";
                                                        echo"<div class='propic_from_list'";
                                                        if($chat_type=='userID')
                                                            echo" id='propic_from_list$chatID'";
                                                        echo"style='background-image:url(".
                                                                    $chatImage.");'>
                                                            </div>
                                                            <p class='chat_name'>$chatName</p>
                                                            <span class='mess_preview'>$mess_text</span>
                                                            <span class='time_preview'>$date_time</span>
                                                        </div>
                                                    </a>
                                                </td></tr>";

                                        }

                                ?>
                        </table>