travelproj
08-22-2011, 12:23 AM
<div id="content">
<p>
Where would you like to go?
</p>
<form method="post" action="http://localhost/list2.psp">
City:
<select name = "City">
<%
cursor.execute("SELECT * FROM location")
result = cursor.fetchall()
for record in result:
%>
<option value="<%= record[1] %>"><%= record[1] %></option>
<%
boop
%>
</select>
State:
<input type="text" id="State" name="State" size="20" maxlength="50"/>
<br>
I have this script working. all except after the last 3 lines of code starting from "State: ..." nothing is printing after my scroll down menu... assuming mayb after </select>
I have my code looping though html grabbing data through mysql, but after I run this, I can't see any of my other code. Am I missing something?
<p>
Where would you like to go?
</p>
<form method="post" action="http://localhost/list2.psp">
City:
<select name = "City">
<%
cursor.execute("SELECT * FROM location")
result = cursor.fetchall()
for record in result:
%>
<option value="<%= record[1] %>"><%= record[1] %></option>
<%
boop
%>
</select>
State:
<input type="text" id="State" name="State" size="20" maxlength="50"/>
<br>
I have this script working. all except after the last 3 lines of code starting from "State: ..." nothing is printing after my scroll down menu... assuming mayb after </select>
I have my code looping though html grabbing data through mysql, but after I run this, I can't see any of my other code. Am I missing something?