How to show downloadlink to binary file?

Friday 05 March 2004 7:08:00 am

I have created a content class for storing files with title, date and the file (binary).
Now i want to show a list of all files with a clickable link to download the file.

How to do this, i don't see it documented anywhere

Saturday 06 March 2004 1:50:16 pm

i want to display contents from a table which has 2 fields, each row will be an <option> of the <select>

table = (country | city)

i fetch the db, an array return as result, this array will have field names as keys pointing to arrays of data, my main problem is how i loop elements from an array, with different keys

my code is something like this:
$elements == resulting array from db fetch

<select name="sel">
{section name=seccion loop=$elements}

<option value="{$seccion:item.city}">{$seccion:item.country}</option>

{/section}
</select>

aany help on this topic or in "how to loop an bi-dimensional array with keys" will be great

thx, javier sanchez-galan