Question about variables stored in a db

[Adrian Schneider]

Hi,

You will probably want to use some vBulletin's database object as well as template system - it will make things much easier. You are actually looking to append the data, rather than replace it each time. In my below example I use .= instead of = to add it to the end of the variable.

PHP Code:

$result = $db->query_read("
    SELECT *
    FROM plugin_frontpage_news
    ORDER BY pfn_id DESC
");

$newsbits = '';
while ($item = $db->fetch_array($result))
{
    $newsbits .= "<strong>$item[pfn_title]</strong><br />$pfn_content<br /><br />";
    
    // or below, and have your HTML as it is above in a template
    eval('$newsbits .= "' . fetch_template('your_newsbit_template') . '";');
}

eval('print_output("' . fetch_template('your_news_template') . '");');