Custom Coded Page into Template

[AreaZeroOne]

Hi.

I'm making a custom vB page and I need to grab about 25 results from the database (not the vbulletin database) that will be displayed there (php/mysql). I'm using a while loop to grab the data. The problem is, I have absolutely no idea how to send that info into the vbulletin template.

I can assign data to variables (like $a = 1) but I don't know how to assign the array along with executing the html properly in the vB template. Help!

[MoT3rror]

PHP Code:

$results = $db->query_read("SELECT * FROM table");

while($row = $db->fetch_array($results))
{
eval('$data =. "' . fetch_template('template_name') . '";');
} 


Then $data will contain html that is sent through the loop.

[AreaZeroOne]

I went searching for another while loop and forumdisplay had one. I saw the eval() statement and it all clicked Man is it much easier once things are clearly understood.

Thanks for the help, appreciate it!

[Adrian Schneider]

Make sure to flip around the period and equals sign in the eval call.

PHP Code:

$results = $db->query_read("SELECT * FROM table");

$data = '';

while ($row = $db->fetch_array($results))
{
    eval('$data .= "' . fetch_template('template_name') . '";');
}