OK sorry this is going to be so long.
I (along with some forum help and a friend) was able to come up with
this. I have to asp pages made.
registration_form.asp is where the form is laid out. it looks like
this
--
<html>
<head>
<title>Tournament Registration</title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
</head>
<body>
<%
'do not leave any spaces in your field names in the database, this will
cause you many headacks in the future
'first thing first, we need to connect to database
'change this line accordingly to the location of database
dim strDBPath
'strDBPath = server.mappath("/db/sasha_online.mdb")
strDBPath = server.MapPath("BNR_Reg.mdb")
'for me this is a generic connection to any database
dim oConn
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Mode = 3
'default adModeUnknown
oConn.CursorLocation = 3
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strDBPath & ";Jet OLEDB:Database;"
'now we need to get the last number from our table
'this sql query is the criteria that we will do the search on
dim sql
sql = "select max(team_number) AS MaxOfteam_number from reg_table"
dim rs
'run the query and save our results in rs
set rs = server.CreateObject("adodb.recordset")
set rs = oConn.execute(sql)
'now we will make sure that the result acctually returned something if
it did not its simply because we are on the first team
'so we will give the value of one in that case
dim team_number
if rs.eof = true then
team_number = 1
else
team_number = rs(0)
team_number = team_number + 1
'we grabed the max number from our table and added 1 for the next
team
'this could be a problem if 2 teams are registering at the same
time
end if
'we need to close the recordset and connection to free up the server
memory
set oConn = nothing
set rs = nothing
%>
<p>Bump-N-Rump is an annual volleyball tournament hosted by the Texas
A&amp;M
Chapter of Delta Sigma Pi. All proceeds from the tournament
proceed the Candlelighters
Childhood Cancer Family Alliance. </p>
<form name="register_form1" action="register.asp" method="post" >
<p> </p>
<p><em><font size="2" face="Georgia, Times New Roman, Times,
serif">Team
Category
<select name="select"> <option
value="Co-Ed" selected>Co-Ed</option>
<option value="Mens">Men's Division</option>
<option value="Womens">Women's Division</option>
</select> <br> <BR>Team
Number:<%=team_number%> <BR><BR>Team Name
<input name="Team" >
</font></em></p>
<P><font size="2" face="Georgia, Times New Roman, Times, serif"><em>
Team Captain will be the contact
member of the team. He will recieve all emails and calls
regarding the
tournament and will be contacted about payment information.
</em></font></P>
<P><FONT face="Georgia, Times New Roman, Times, serif"
size=2><EM>Captain Name
<input name="txtCapt_Name" id="txtCapt_Name"
<br> Captain Phone Number
<input name="txtCapt_Phone" id="txtCapt_Phone" <br>
Captain Email Address
<input name="txtCaptEmail" id="txtCaptEmail" <br> </EM></FONT></P>
<P><FONT face="Georgia, Times New Roman, Times, serif" size=2><EM>Teams
may have
up to 6 pleyers on a team. Please enter the names of your
other teams
members.</EM></FONT></P>
<P> <font size="2" face="Georgia, Times New Roman, Times,
serif"><em> Additional Member
<input name="txtMember2_Name" id="txtMember2_Name" >
<br> Additional Member
<input name="txtMember3_Name" id="txtMember3_Name" >
<br> Additional Member
<input name="txtMember4_Name" id="txtMember4_Name" >
<br> Additional Member
<input name="txtMember5_Name" id="txtMember5_Name" >
<br> Additional Member
<input name="txtMember6_Name" id="txtMember6_Name" </em></font> </P>
<P><EM>**Note** You should recieve an email confirming your
registration within
24 hours.</EM></P>
<p><em><font size="2" face="Georgia, Times New Roman, Times,
serif"> <input type="reset" name="Submit2" value="Reset">
<input type="submit" name="Submit" value="Submit">
</font></em></p>
</form>
<a href="http://www.aggiedeltasigs.com"><em>back to home</em></a><br>
</body>
</html>
---
