<script language="JavaScript" type="text/JavaScript"> 
<!-- 
function jumpMenu(targ,selObj,restore){ //v3.0 
eval(targ+".location='"+selObj.options.value+"'"); 
if (restore) selObj.selectedIndex=0; 
} 
//--> 
</script>

<form name="selezione" method="post" action="prenota.asp"> 
<% 
pagina = request.servervariables("path_info") 
id = request.querystring("id") 

if len(id) > 0 and isnumeric(id) then 
id = clng(id) 
else 
id = 0 
end if 

Set Conn = Server.CreateObject("ADODB.Connection") 
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" &_ 
"DBQ="& Server.MapPath("\database\mpdb.mdb") 

sql = "select * from locale where Pr=true" 

set rs = conn.execute(sql) 

if not rs.eof then 
%> 
<select name="nome" id="nome" onChange="jumpMenu('parent',this,0)"> 
<option value="<%=pagina%>?id="></option> 
<% do until rs.eof %> 
<option value="<%=pagina%>?id=<%=rs("ID")%>"<% if rs("ID") = id then %> selected<% end if %>><%=rs("Nome")%></option> 
<% 
rs.movenext 
loop 
end if 
%> 
</select> 
<br> 
<br> 
<% 
rs.close 
set rs = nothing 

if id > 0 then 

sql = "select * from ingressi where locale_ID = " & id 

set rs = conn.execute(sql) 

if not rs.eof then 
%> 
<select name="giorni" id="giorni"> 
<option value="<%=rs("locale_ID")%>"></option> 
<% do until rs.eof %> 
<option value="<%=rs("locale_ID")%>"><%=rs("giorno1")%&g t;</option> 'togliere stringa 
<option value="<%=rs("giorno1")%>"<% if rs("locale_ID") = id then %> selected<% end if %>><%=rs("giorno1")%></option> 
<% 
rs.movenext 
loop 
end if 
%> 
</select> 
<br> 
<br> 
<% 
rs.close 
set rs = nothing 

end if 

conn.close 
set conn = nothing 
%> 
<select name="num" disabled="true" class="memugiallo" id="num"> 
</select> 
<select name="mese" disabled="true" class="memugiallo" id="mese"> 
</select><br/> 
<input name="nome" disabled="true" type="text" class="memugiallo" id="nome"> 
<br/> 
<input name="cell" disabled="true" type="text" class="memugiallo" id="cell"> 
<br/> 
<input name="mail" disabled="true" type="text" class="memugiallo" id="mail"> 
<br/> 
<select name="pers" disabled="true" class="memugiallo" id="pers"> 
</select> 
<br/> 
<input name="tavolo" type="radio" disabled="true" value="si"> 
<input name="tavolo" type="radio" disabled="true" value="no" checked> 
<br/> 
<input type="submit" name="Submit" value="Submit"> 
</form>