text not echoing out

[sabret00the]

$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

$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 :D