translate to VB code

[zardos]

How do i translate to VB code?

PHP Code:

$sql = "SELECT mess FROM gb ORDER BY datum DESC limit 15";

//H?mta ur databas
$result = mysql_query($sql) or die(mysql_error());
 
while ($row = mysql_fetch_assoc($result)){
   echo 'mess :&nbsp;'.$row['mess']. '&nbsp; <br />';

} 


And what part should be in the template?

[rjmjr69]

Whats it for whats it do?

[zardos]

It connects to the database and write out the info in a while lope?

[Paul M]

PHP Code:

$result = $vbulletin->db->query_read("
    SELECT mess FROM gb
    ORDER BY datum DESC limit 15
");

$output = '';
while ($row = $vbulletin->db->fetch_array($result)) 
{
    eval('$output.= "' . fetch_template('Your_Template') . '";');
} 


"Your_Template" would be used to format each line.

The resulting variable $output can then be included in the template you are using to display the whole page.

[zardos]

Nice, and thank you!