[Kiint]

I haven't really looked at your code, but this is what I use on my site in the profile of each person, I have a page that has this code:

PHP Code:

$result = $db->query("SELECT * FROM " . TABLE_PREFIX . "`eqdkp_items`
                               LEFT JOIN eqdkp_raids ON eqdkp_items.raid_id=eqdkp_raids.raid_id
                               WHERE `item_buyer` = \"".$chardata[fname]."\"
                               ORDER BY `item_date` DESC");
    $ii = $db->num_rows($result);
    while($loot = $db->fetch_array($result)) {
        $lootdate = date("D, F j, Y, g:i a", $loot[item_date]);
  eval('$loothistory .= "' . fetch_template('roster_profile_loot') . '";');
 }
    $db->free_result($result); 


Then a template called 'roster_profile_loot' with the following in it:

<tr>
 <td class="alt1" align="left">
 <a href="http://www.yoursite.com/eqdkp/viewitem.php?s=&i=$loot[item_id]" target="_blank">$loot[item_name]</a></td>
 <td class="alt2" align="left">
 <a href="http://www.yoursite.com/eqdkp/viewraid.php?s=&r=$loot[raid_id]"  target="_blank">$loot[raid_name]</a></td>
 <td class="alt1" align="left">
 $lootdate
 </td>
</tr>

Hope this helps a little