can't get more than 1 row from Database.

[vietfancy]

PHP Code:

<?php

// Get Schedule
$mon = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "schedule WHERE day like '%Monday%' ORDER BY time");

$schedule_mon = "<b>$mon[time]</b> - <b>$mon[ampm]</b> - <b>$mon[class]</b> - <b>$mon[level]</b> - <b>$mon[instructor]</b>";

// end Get Schedule

// ###### TEMPLATE IS BEING RENDERED ######
$templater = vB_Template::create('schedule');
$templater->register_page_templates();
$templater->register('navbar', $navbar);
$templater->register('pagetitle', $pagetitle);
$templater->register('schedule_mon', $schedule_mon);
print_output($templater->render());

?>

I used this code in the template and it only shows 1 row from the database. Did I do anything wrong?

{vb:raw schedule_mon}

Image:

[PitchouneN64ngc]

Query_first() returns only the 1st result from the database.

You must use query_read and fetch_array() for having more lines.

PHP Code:

<?php 

$schedule_mon = '';

// Get Schedule
$mons = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "schedule WHERE day like '%Monday%' ORDER BY time");

while ($mon = $db->fetch_array($mons))
{
     $schedule_mon .= "<b>$mon[time]</b> - <b>$mon[ampm]</b> - <b>$mon[class]</b> - <b>$mon[level]</b> - <b>$mon[instructor]</b>";
}

// end Get Schedule

// ###### TEMPLATE IS BEING RENDERED ######
$templater = vB_Template::create('schedule');
$templater->register_page_templates();
$templater->register('navbar', $navbar);
$templater->register('pagetitle', $pagetitle);
$templater->register('schedule_mon', $schedule_mon);
print_output($templater->render());

?>

[ForumsMods]

Why don't you use vb:each?

[vietfancy]

Thanks guys.

Adrian. How do i use vb:each?

Thanks

[ForumsMods]

Sorry, vb:each is not what you need.