[sabret00the]

thanks both of you, the working code is now

PHP Code:

    $latestconfession = $DB_site->query_first ("
                    SELECT COUNT(*) AS votes, confessions.confessionid, confessions.visible,
                    confessions.text, confession_rate.rate, user.username
                    FROM confessions
                    LEFT JOIN confession_rate ON (confessions.confessionid = confession_rate.confessionid)
                    LEFT JOIN user ON (user.userid = confessions.userid)
                    WHERE confessions.visible = 1
                    GROUP BY confessions.confessionid
                    ORDER BY confessions.confessionid DESC
                    LIMIT 1 
                ");

    $latestconfession['text'] = nl2br(stripslashes($latestconfession['text']));
    if (strlen($latestconfession[text]) > 150)
    {
        $latestconfession['text'] = substr($latestconfession['text'],0,150)."...";
    }

    if ($latestconfession['rate'] == NULL)
    {
        $latestconfession['rate'] = "0";
    }

    eval('$siteindex_contentbox .= "' . fetch_template("siteindex_confessions") . '";');