text not echoing out

[sabret00the]

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_info = $DB_site->fetch_array($latestconfession);
 
     $latestconfession_info['text'] = nl2br(stripslashes($latestconfession_info['text']));
     if (strlen($latestconfession_info[text]) > 150)
     {
         $latestconfession_info['text'] = substr($latestconfession_info['text'],0,150)."...";
     }
 
     $latestconfession_info_text = "$latestconfession_info[text]";
     $latestconfession_info['num_rates'] = number_format($latestconfession_info['votes']);
     extract($latestconfession_info);
 
     eval('$siteindex_contentbox .= "' . fetch_template("siteindex_confessions") . '";'); 


the problem is that $latestconfessions_info_text isn't eachoing out into the template

[amykhar]

If it's 0, it won't. Try echoing $latestconfessions_info_text + "Test". If that works, you'll know your text isn't getting set.

[sabret00the]

i tried that and it never worked, yet i know the text is there as i can get it via the query, i'm not quite sure where i've gone wrong from doing the query to trying to echo it out as it seems to be getting lost.

[Modin]

You don't need to fetch the array after calling the function "$DB_site->query_first()". query_first already returns an array of the first row of the result.

So try removing

$latestconfession_info = $DB_site->fetch_array($latestconfession);

and then fix up your variables to match.

[Colin F]

Check that this whole thing is not in an if or while clause that's not being executed.

Do you have a template siteindex_confessions? (ok, rather basic question, but spelling errors can happen )

why do you call $latestconfession_info_text instead of just $latestconfession_info[text] ??
You might also want to take away those ""'s

[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") . '";'); 


[Modin]

great to see