How could I modify this code to enable a user to update the pups available field
<BODY><TABLE BORDER=1>
<THEAD>
<TR>
<TH>BreederNo</TH>
<TH>Breeder Name</TH>
<TH>Phone No.</TH>
<TH>Address</TH>
<TH>Pups Available</TH>
</TR>
</THEAD>
<% var str_DogName = new String(Request.Form("DogName");
if (str_DogName! = "undefined"{
%>
<%
// Open connection to database, then populate a recordset with list of Breeders
var adoConnection = Server.CreateObject("ADODB.Connection"
var adoRecordSet;
var mySQL;
adoConnection.Open("DSN=DogDSN"
var mySQL = 'SELECT BreederNo,BreederName,BrPhoneNo ,BrAddress, PupsAvailable' +
' FROM Breeders WHERE BreedName ="' + str_DogName +'"';
adoRecordSet = adoConnection.Execute(mySQL);
// Loop through recordset and write stock details out to page
while ( adoRecordSet.Eof == false )
{
%>
<TR>
<TD><%=adoRecordset("BreederNo".Value%></TD>
<TD><%=adoRecordSet("BreederName".Value%></TD>
<TD><%=adoRecordSet("BrPhoneNo".Value%></TD>
<TD><%=adoRecordSet("BrAddress".Value%></TD>
<TD><%=adoRecordset("PupsAvailable".Value%></TD>
<TD><A HREF="BookPup.asp?BreederNo=<%=adoRecordSet("BreederNo".Value%><!--mstheme--></font></TD> <TD><!--mstheme--><font face=" Helvetica" Arial,> Book pup</A></TD>
</TR>
<%
adoRecordSet.MoveNext();
}
// Close Recordset and connections
// and release memory used by Recordset and Connection objects
adoRecordSet.Close();
adoRecordSet = null;
adoConnection.Close();
adoConnection = null;
%>
</TABLE></BODY>
</HTML>
<BODY><TABLE BORDER=1>
<THEAD>
<TR>
<TH>BreederNo</TH>
<TH>Breeder Name</TH>
<TH>Phone No.</TH>
<TH>Address</TH>
<TH>Pups Available</TH>
</TR>
</THEAD>
<% var str_DogName = new String(Request.Form("DogName");
if (str_DogName! = "undefined"{
%>
<%
// Open connection to database, then populate a recordset with list of Breeders
var adoConnection = Server.CreateObject("ADODB.Connection"
var adoRecordSet;
var mySQL;
adoConnection.Open("DSN=DogDSN"
var mySQL = 'SELECT BreederNo,BreederName,BrPhoneNo ,BrAddress, PupsAvailable' +
' FROM Breeders WHERE BreedName ="' + str_DogName +'"';
adoRecordSet = adoConnection.Execute(mySQL);
// Loop through recordset and write stock details out to page
while ( adoRecordSet.Eof == false )
{
%>
<TR>
<TD><%=adoRecordset("BreederNo".Value%></TD>
<TD><%=adoRecordSet("BreederName".Value%></TD>
<TD><%=adoRecordSet("BrPhoneNo".Value%></TD>
<TD><%=adoRecordSet("BrAddress".Value%></TD>
<TD><%=adoRecordset("PupsAvailable".Value%></TD>
<TD><A HREF="BookPup.asp?BreederNo=<%=adoRecordSet("BreederNo".Value%><!--mstheme--></font></TD> <TD><!--mstheme--><font face=" Helvetica" Arial,> Book pup</A></TD>
</TR>
<%
adoRecordSet.MoveNext();
}
// Close Recordset and connections
// and release memory used by Recordset and Connection objects
adoRecordSet.Close();
adoRecordSet = null;
adoConnection.Close();
adoConnection = null;
%>
</TABLE></BODY>
</HTML>