Dynamic listbox

Jeff

Hello, I am having trouble with an ASP page that seems really simple. It adds data to the d/b fine with three text fields; firstname, lastname and team id. The problem; I would like the team id to come from a listbox built from the teams table. I don't understand how to include the dynamic listbox on the same form that requests the other data from the user. I can make it work if I create a separate page but I want it to be a part of the first page. I am confused on whether it should be a get or post and all of that. Is there any code that combines some text input boxes As Well as a dynamic list box out there? I think if I got this as a foundation I could move forward. Thanks in advance.

matto

hi,

first of all, this is a php forum. I suppose you're talking about asp/vbscript.

then, I happen to be working on an asp site argh where external script parts are included like this (outside <% %>):

finally, I don't know if you have the choice, but I strongly recommend switching to php - maaaany things work so much easier with it than with asp.

😉

matto

barand

You need to do something like this

<select name="teamid">
<%
connect to database
do query "select team_id from teams"
while not eof
response.write "<option value="query['teamid']">query['teamid'] </option>"
end while
%>
</select>

HTH