First lets look at the PHP code

php Code:

$qry = "SELECT * FROM {$CONFIG->dbprfx}users ORDER BY user_posts DESC LIMIT 5";         $res = $DB->query($qry);         while($row = $res->fetchRow(DB_FETCHMODE_ASSOC))         {             $usernames .= "Username: ".$row['userid']." (Posts: ".$row['user_posts'].") ";                         $TEMPLATE->assign('username', $usernames);         } $this->pagename = "mypage.tpl";

First we do a common task and retrieve data from the database.  Within the while loop we are assigning a string to a variable to be passed through the "assign" function.
The data $username holds gets sent to $TEMPLATE->assign('username', $usernames);.
The first argument is for the loop in the .tpl file. The second argument holds the data we want to send to the .tpl file

In mypage.tpl we have "foreach loop".

html Code:

{foreach from=$username item=user_name}     {$user_name}     {/foreach}

The parameter from=$username is relative (is that the correct term?) to the first parameter of the "assign" function.
The parameter item=user_name is unique and doesn't have to be anything special.
The code within the "foreach" tags is the same as the value of "item".

This was a quick explaination. If you have any problems I'll help.

Last edit by harmor on Dec 31, 1969, 7:00 pm

---

Xen Web Hosting Offering ad-free hosting with features such as, cpanel, fantastico, PHP and MySQL support, and more -------------------------------------------------------------------------------------------------------

Chris

Let's hang on to Harmor, it's not everyday that you find people who walk the walk, not just talk the talk.