Hi, I need help displaying information from my database. I'm using a php file and then an html file for the template itself. My php looks something like this:
Code: Select all
$result = $db->query("SELECT * FROM `my_table_here` ORDER BY `field_i_want_to_sort_by` DESC LIMIT 0,10");
{
$tmp->set_block( 'my_list', $row );
}
I want to display the information in html like this:
Code: Select all
<!-- start my_list -->
{my_list.field_1}, {my_list.field_2}<br />
<!-- stop my_list -->
So basically, I want to display the different fields of that table. What changes do I need to make to make this work? If you can explain any of the "how"'s or "why"'s of it, that would be cool too. Thanks.