<?php
$date = date("Y-m-d");

$query = "SELECT
    gtdr_user.name AS u_name,
    gtdr_user.id AS u_id,
    gtdr_user.email AS u_email,

    gtdr_calender.id AS c_id,
    gtdr_calender.headline AS c_headline,
    gtdr_calender.date AS c_date,
    gtdr_calender.created_date AS c_created_date,
    gtdr_calender.text AS c_text

    FROM gtdr_calender
    LEFT JOIN gtdr_user

    ON gtdr_calender.created_by = gtdr_user.id

    WHERE gtdr_calender.date >= $date
    ORDER BY gtdr_calender.id DESC";

$result = mysql_query($query) or die(mysql_error());
while ($resultdata = mysql_fetch_object($result)) {
?>
<p>
    <table width="880" border="0" class="textWhite" cellspacing="0" cellpadding="0">
        <tr valign="top" height="20">
            <td align="left" class="textHeaderBlue">
                <?php echo $resultdata->c_headline; ?>
            </td>
        </tr>
            <tr valign="top" height="12">
            <td align="left" class="textNewsBox">
                <?php echo $resultdata->c_date; ?>
            </td>
        </tr>
        <tr valign="top">
            <td align="left">
                <?php echo nl2br($resultdata->c_text); ?>
            </td>
        </tr>
        <tr valign="bottom" height="20">
            <td align="left" class="textWhiteItalic">
                <img src="img/newsBoxLine.png" width="100%" height="1">
                Skriven av: <a href="?sida=profil&id=<?php echo $resultdata->u_id; ?>"><?php echo $resultdata->u_name; ?></a> <?php echo $resultdata->c_created_date; ?><br />
                <img src="img/newsBoxLine.png" width="100%" height="1">
            </td>
        </tr>
    </table>
</p>
<?php } ?>