SOLVED! - starting help, using php <-> templates <-> db

[Vaupell]

so your saying i need to

1) Query
$getcontentA= $vbulletin->db->query_first(" ....

2) Start an array ?
while ($data = $vbulletin->db->fetch_array($getcontentB){

3) Then eval
eval('$data.= "' . fetch_template('test_testa') .'";');

4) end the while
}

Just to display a single row of colums, which i allready have selected in the query using WHERE.

... well of to bed, dosent make sence at all.

EDIT just tryed something else..

PHP Code:

$result = $vbulletin->db->query_read("SELECT RID, Rtitle, Rdesc, Rscore, Ruid, Rlink, FROM " . TABLE_PREFIX ."evireviewpost WHERE RID = 1");
while ($row = $db->fetch_array($result))
{
    $rowid = $row['RID']; 
    $Rtitle = $row['Rtitle']; 
    $Rdesc = $row['Rdesc']; 
    $Rscore = $row['Rscore']; 
    $Ruid = $row['Ruid']; 
    $Rlink = $row['Rlink']; 
    eval('print_output .= "' . fetch_template('test_testa') . '";');
} 


But this just gives me a unspecified error at last line ?> EDIT 2, ; error,, parseing,

getting db errro instead. 'FROM evireviewpost WHERE RID = 1' at line 1
just checking this out..
EDIT 3 DB error sorte, its now working..

back to a "blank" page as result.. lol wTH..

working query

PHP Code:

$result = $vbulletin->db->query_read("SELECT RID, Rtitle, Rdesc, Rscore, Ruid, Rlink FROM " . TABLE_PREFIX . "evireviewpost WHERE RID = 1");
while ($row = $vbulletin->db->fetch_array($result))
{
    $rowid = $row['RID']; 
    $Rtitle = $row['Rtitle']; 
    $Rdesc = $row['Rdesc']; 
    $Rscore = $row['Rscore']; 
    $Ruid = $row['Ruid']; 
    $Rlink = $row['Rlink']; 
    eval('$row .= "' . fetch_template('test_testa') .'";');
} 


partial from the template

	<td class="tcat"> TEST </td>
</tr><tr>
<td> $rowid - $Rdesc</td>
</tr><tr>
<td> normal text </td>

--------------- Added [DATE]1234656725[/DATE] at [TIME]1234656725[/TIME] ---------------

allright GOT IT WORKING..

ADDED php]eval('print_output("' . fetch_template('test_testa') . '");');[/php]
at the end,, taddaa it "pint" the whole ting.

omg, crazy,, i think i got it..