db->query_read error

[thesatman]

Hi, Sorry got 1 more quick question. I'm using the following code to display the top 10 attachments-

$top_stats = array();
// TOP POSTERS
$top_posters = $db->query_read("SELECT * FROM ".TABLE_PREFIX."attachment ORDER BY counter DESC LIMIT 10");
while($top_poster = $db->fetch_array($top_posters))
{
eval('$top_stats[\'top_posters\'] .= "' . fetch_template('top_posters') . '";');
}
unset($top_poster);
$db->free_result($top_posters);
eval('$home[$mods[\'modid\']][\'content\'] = "' . fetch_template('adv_portal_topposters') . '";');

And then i'm using the folling in the template-

$top_poster[filename]

the above is working and displays the attachment like-

filname.mp3

What i'd like to do is display the file name without the .mp3 extension, so like-

filename

What would i use to get rid of the .mp3

Thanks chris.