Looping templates help

[veenuisthebest]

I have referred to this and this

Now, in my PHP file, I have this:-

PHP Code:

$query=$db->query_read("SELECT * FROM " . TABLE_PREFIX . "mytable ORDER BY `uid` DESC LIMIT " . ($limitlower - 1) . ", $perpage");
while ($result = $db->fetch_array($query))
{
$row_id=$result['uid'];
$row_name=$result['name'];

foreach ($result as $key => $value)
{
eval('$maindata .= "' . fetch_template('loopy_template') . '";');
}} 


I have simply copied the foreach part from the above mentioned links.

What arguments I need to pass to foreach and how ? Do I need to do something before it also ? Please guide me on how to correct the above code.

Thank You