SMARTY, how do you pull data from MySQL and store into array...

[solidcodes]

Hello

How do you pull MULTIPLE COLUMNS from Mysql then store the values into array using PHP and later display it onto SMARTY?

Can you show example codes for this please.

Anyone out there with humble heart please.
I"m scratching my head for this in many days.

Thanks in advance.

[thewebhostingdir]

I exactly do not understand the requirement. When you write a SELECT query as per your needs and then do mysql_fetch_array(), it will return the array of columns. Please elaborate the needs if different.

[solidcodes]

@thewebhostingdir

can you help me. please...

[solidcodes]

*bump*
any help please.

[AnthonySterling]

It's in the documentation, in fact, it's on this very page.

http://www.smarty.net/manual/en/api.assign.php

[oddz]

I'm new to smarty so take this with a grain of salt:

Assign headings and row data:

...
$smarty->assign('myHeadings',$headings);
$smarty->assign('myData',$data); 

Template:

<table>

{foreach key=key item=value from=$myHeadings name=outerHead}
{if $smarty.foreach.outerHead.first}<thead><tr>{/if}
    <td>{$value}</td>
{if $smarty.foreach.outerHead.last}</tr></thead>{/if}
{/foreach}

{foreach key=key item=value from=$myData name=outer}
{if $smarty.foreach.outer.first}<tbody>{/if}
<tr>
    {foreach key=key2 item=value2 from=$value}
        <td>{$value2}</td>
    {/foreach}
</tr>
{if $smarty.foreach.outer.last}</tbody>{/if}
{/foreach}

</table>