ciao a tutti,
db con tabella portico_sett che contiene tanti campi
ID, LUNE, MARTE, MERCO....DOME

ora vorrei estrarre in una tabella l'ultimo record di ogni campo, ho fatto così ma estrae solo l'ULTIMO in assoluto, quindi o lune o marte o merco ecc..

codice:
  <%
		  		oRst.Open "SELECT * FROM portico_sett order By ID Desc ;", oConn
				 
		  %>
</table>
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="3%" rowspan="2"></td>
    <td width="30%" rowspan="2"><span class="Stile1"><span class="Stile11">
    </span></span>
      <table width="328" height="213"  border="1" cellpadding="0" cellspacing="0" bordercolor="#666666">
        <tr>
          <td colspan="2" class="Stile1 Stile2">Programma Settimanale delle serate </td>
        </tr>
        <tr>
          <td width="17%" class="Stile1 Stile2">Luned&igrave;</td>
          <td width="83%" class="Stile1"><span class="Stile11"><%=oRst("lune").Value%></span></td>
        </tr>
        <tr>
          <td class="Stile5">Marted&igrave;</td>
          <td class="Stile1"><span class="Stile11"><%=oRst("marte").Value%></span></td>
        </tr>
        <tr>
          <td class="Stile5">Mercoled&igrave;</td>
          <td class="Stile1"><span class="Stile11"><%=oRst("merco").Value%></span></td>
        </tr>
        <tr>
          <td class="Stile5">Gioved&igrave;</td>
          <td class="Stile1"><span class="Stile11"><%=oRst("giove").Value%></span></td>
        </tr>
        <tr>
          <td class="Stile5">Venerd&igrave;</td>
          <td class="Stile1"><span class="Stile11"><%=oRst("vene").Value%></span></td>
        </tr>
        <tr>
          <td class="Stile5">Sabato</td>
          <td class="Stile1"><span class="Stile11"><%=oRst("saba").Value%></span></td>
        </tr>
        <tr>
          <td class="Stile5">Domenica</td>
          <td class="Stile1"><span class="Stile11"><%=oRst("dome").Value%></span></td>
        </tr>
      
      </table>      </td>  
        <%
oRst.Close
%>
grazie