Chatroom Listener

<?php

include 'includes/main.inc.php';

if (isset($_POST['name']) && $_POST['name'] != '') {

    $today = date("Y-m-d");

    $select = $db->select("SELECT * FROM chat WHERE `date`=" . $db->mySQLSafe($today));
    if ($select != null) {

        $chat = unserialize($select[0]['chat']);

        $chat[] = array('chat'=>$_POST['chat'], 'name'=>$_POST['name']);

        $db->update('chat', array('chat'=>$db->mySQLSafe(serialize($chat))), '`date`=' . $db->mySQLSafe($today));

    }else{

        $db->insert('chat', array('chat'=>$db->mySQLSafe(serialize(array(0=>array('chat'=>$_POST['chat'], 'name'=>$_POST['name'])))),
                'date'=>$db->mySQLSafe($today)));

    }

} else {

    $today = date("Y-m-d");

    $select = $db->select("SELECT * FROM chat WHERE `date`=" . $db->mySQLSafe($today));
    if ($select != null) {
        $chat = array_reverse(unserialize($select[0]['chat']));
        foreach ($chat as $k => $l) {
            echo $l['name'] . ': ' . $l['chat'] . '<br />';
        }
    } else {
        echo 'There is no chat for today. How about you start some.';
    }
}