Ziskanie nazvov stlpcov z vysledku databazoveho dotazu

kiri
Člen | 13
+
0
-

Ahojte.
Uz par dni hladam a neviem nic najst.

Ak v presenteri priamo pomocou Query vytvorim dotaz,
a to napriklad aj s vlastnym pomenovatim stlpcov, viem sa v latte nejak dostak k nazvom stlpcov z nejakych metadat $result ?
Chcel by som s nimi napriklad vypnit zahlavie tabulky. Aby som po prerobeni Query nemusel znovu opravovat nazvy stlpcov v zahlavi tabulky v latte.

$result = $this->database->query('
        SELECT
            DAYNAME(datum) as den,
            DATE_FORMAT(datum, \'%d.%m.%Y\') AS datum,
            DATE_FORMAT(cas, \'%H.%i\') AS cas,
            zakaznik,
            case tel_obj
                when 0 then \'WEB\'
                else \'TEL\'
                end as tel_obj,
            telefon,
            typ_auta,
            znacka_auta,
            spz,
            case tk
                when 0 then NULL
                else \'TK\'
                end as tk,
            case ek
                when 0 then NULL
                else \'EK\'
                end as ek,
            email
        FROM test;
        ');
    $this->template->rows = $result;
	...
	<table class='zoznam'>
        <tr>
            <th>den</th>
            <th>datum</th>
            <th>cas</th>
            <th>zakaznik</th>
            <th>sposob objednania</th>
            <th>telefon</th>
            <th>druh vozidla</th>
            <th>vyrobca</th>
            <th>SPZ</th>
            <th>TK</th>
            <th>EK</th>
            <th>e-mail</th>
        </tr>
    {foreach $rows as $row}
	    <tr>
	        <td>{$row->den}</td>
	        <td>{$row->datum }</td>
	        <td>{$row->cas}</td>
	        <td>{$row->zakaznik}</td>
	        <td>{$row->tel_obj}</td>
	        <td>{$row->telefon}</td>
	        <td>{$row->typ_auta}</td>
	        <td>{$row->znacka_auta}</td>
	        <td>{$row->spz}</td>
	        <td>{$row->tk}</td>
	        <td>{$row->ek}</td>
	        <td>{$row->email}</td>

	    </tr>
    {/foreach}
	...
Kamil Valenta
Člen | 844
+
+2
-
<table class='zoznam'>
    {foreach $rows as $row}
		{if $iterator->isFirst()}
		<tr>
		{foreach $row as $col => $val}
            <th>{$col}</th>
        {/foreach}
        </tr>
		{/if}
	    <tr>
	        <td>{$row->den}</td>
	        <td>{$row->datum }</td>
	        <td>{$row->cas}</td>
	        <td>{$row->zakaznik}</td>
	        <td>{$row->tel_obj}</td>
	        <td>{$row->telefon}</td>
	        <td>{$row->typ_auta}</td>
	        <td>{$row->znacka_auta}</td>
	        <td>{$row->spz}</td>
	        <td>{$row->tk}</td>
	        <td>{$row->ek}</td>
	        <td>{$row->email}</td>
	    </tr>
    {/foreach}
kiri
Člen | 13
+
0
-

Ahaaa.
Uz mi to doslo.
To bude tym, ze som dlho robil iba C#.
Dakujem.