Populating Drop down

[farzou]

Hi All

I'm very new to Cach� and I was wondering if it is possible to populate a
drop-down in HTML base on values from another table..

Extract of the code
<csp:QUERY NAME="tst" CLASSNAME="MediaOnline.test" QUERYNAME="tst">
    <table cellpadding="3">
      <tr>
        <td><font color="#666666"><b>
          <div align="RIGHT">*media MediaName:</div>
          </b></font></td>
        <td>
        <select name="mediaMediaName" cspbind="media.MediaName">
            <option value="#(tst.Get("MediaName"))#"></option>
        <csp:while Condition="tst.Next()">
          <option value=>
            </csp:while>

     </option>

Thanks