Insert into Site Stats

Ok, I found out how to add more stats to the Stat block out front. It works...but the text doesn't work.

I get the text "3 _i Århus" (It count the amount of members in the 10 largest cities of Denmark)

This is my SQL-thing:

INSERT INTO `sys_stat_site` (`ID`, `Name`, `Title`, `UserLink`, `UserQuery`, `AdminLink`, `AdminQuery`, `IconName`, `StatOrder`) VALUES
(30, 'aar', ' i Århus', '', 'SELECT COUNT(*) FROM `Profiles` WHERE `City`=''Århus''', '', 'SELECT COUNT(*) FROM `Profiles` WHERE `City`=''Århus''', '', 7);

What I would like is to get the "_" away from the result-text, so it say "3 i århus" instead of "3 _i århus"

Can this be done? and if so - how?

Yes.

In the title space of the site stat your inserting, use a language key _keyname

Language keys start with a _ (underscore) and use latin characters only.

Then add that key in the languages section with a translation for each of your installed languages.

Ok - thanks... But I changed my mind of where I wanted the stats to be. I want them under the map on the front page...

I tried going through some tutorials I found via google, but... no go.

So it is ten variations of

SELECT COUNT(*) FROM `Profiles` WHERE `City`=''Århus''

that I need to have shown under the map...

Is THAT possible???

I tried this, but I don't get the number of cities in the db...

<?php

$query="SELECT COUNT(*) FROM `Profiles` WHERE `City`=''Århus''";
$result=mysql_query($query);

$first=mysql_result($result);
echo "Test";
echo "$first";

?>