Table not looping (smarty)

Darkness2099

Joined: 2009-04-24
Posts: 2
Posted: Fri, 2009-04-24 22:19

Ok, to start i came here cause i seen ppl helping out with smarty.
So far most forums offer no help on this topic i seen so far...

I am trying to get my new page to display up to 20 results from my DB but
so far it just shows the last one, or shows um all in a huge pile.

I have the code in the php part php call to table [ $aff_members ] is it reads it aok and displays it but the part in smarty i think is messed up...

If i place it like this:

Quote:
{$aff_name}, {$aff_join_date}, so on.

I comes out with all of um in one pile.

But if i do it like this in a neat table it only shows the last row if at all.

Quote:
{foreach name=aff from=$aff_members}
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="110" align="center"><img src='{$aff_mem_ico}' class='photo' border='0' width='100' height='100' /></td>
<td class="result_empty"><table width="450" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><b>{$aff_username}</b><br />
Joined: {$datetime->cdate("`$setting.setting_dateformat`", $datetime->timezone("`$aff_join_date`", $global_timezone))}<br />
<a href="{$aff_url}">VIEW THERE SITE</a><br />
Members Reffered: {$aff_reffered}</td>
</tr>
</table></td>
</tr>
</table>
{/foreach}

 
Darkness2099

Joined: 2009-04-24
Posts: 2
Posted: Fri, 2009-04-24 22:21

Forgot to add the header code.

Quote:
$aff_members = $database->database_fetch_assoc($database->database_query("SELECT * FROM se_affiliates_members order by 1 DESC LIMIT 20"));