Mikko,

Not sure if you saw my comment about the code but it did not work, after I tried to echo the value of $cat (which is obtained by the query) yet nothing is shown.

I just stuck that code as you see it on my template, should it have worked or am I missing something?

Jacob

Ah, you need to add

$database->setQuery($sql);

before the line where you fetch the result.

mikko

That did it thanks!

I had to change $sql in your line to $query

Much appreciated.