Professional Web Applications Themes

Sports DB - ASP Database

am new to dynamic web design and am having some trouble designing a db/web form for a hockey team. I am hoping to have a form that will update the records for each player on the team. I have created a table in my DB with the following column headers: playerid (primary, autonumber) playername goals assists points pims shutouts whenever I try to update the table from the form I created in dreamweaver, it overwrites the other entries. Can anyone point me in the right direction? I have been searching around for most of the day and cant find the ...

  1. #1

    Default Sports DB

    am new to dynamic web design and am having some trouble designing a db/web
    form for a hockey team. I am hoping to have a form that will update the
    records for each player on the team.

    I have created a table in my DB with the following column headers:

    playerid (primary, autonumber)
    playername
    goals
    assists
    points
    pims
    shutouts

    whenever I try to update the table from the form I created in dreamweaver,
    it overwrites the other entries. Can anyone point me in the right direction?
    I have been searching around for most of the day and cant find the answer.

    One other thing I was hoping to find out. Is it possible to have the form
    update the record so that the numbers are ulative? For example Tom Smith
    has 4 goals in his next game he scores 2 more, I enter 2 into the form and
    the database changes his goals record to 6. Is this a possibility?


    Whodat Guest

  2. #2

    Default Re: Sports DB

    "Whodat" <com> wrote in message
    news:qsYbd.3967$cgocable.net... 
    direction? 
    Smith 

    "whenever I try to update the table from the form I created in dreamweaver,
    it overwrites the other entries." is like saying "Doctor, something hurts,
    can you cure me?".

    We can't fix what we can't see -- show us your code!


    McKirahan Guest

  3. #3

    Default Re: Sports DB

    Hi sorry for the lack of info, not sure if you would want to see all of
    this - didnt want to spam.

    Since I first posted I have changed the way my DB is setup. It is now like
    this:

    Table BDIV_teamstats contains:

    Gameday
    Opponent
    Goalsfor
    Goalsagainst
    Win
    Loss
    Tie
    Shutout
    GameID (primary)

    Table BPlayers Contains:

    PlayerID (primary)
    Playername
    Playernumber

    Table BPlayerstats contains:
    StaID (primary)
    staPlayerID (related to Bplayer; PlayerID)
    StaGameid (related to BDIV_teamstats; Gameid
    Stagoals
    Staassists
    Stapoints
    StaPims

    I have created a relationship between these tables as I indicated above.
    When there is no data in the pages, everythign is fine. As soon as I enter
    data I get an error:

    "This expression is typed incorrectly, or it is too complex to be evaluated.
    For example, a numeric expression may contain too many complicated elements.
    Try simplifying the expression by assigning parts of the expression to
    variables. (Error 3071)"

    Is this because of Primary keys possibly being the same number? I have been
    told about Foreign Keys? - would doing that help? I really dont know how to
    create them.

    Using windows Xp Sp2 and access 2003, DWMX4. I am not sure where I need to
    change my approach. I am not sure if the error is in my DB design or the
    form design. Anyway I appreciate any help I can get.

    This is the input form code:

    <form method="post" action="<%=MM_editAction%>" name="form1">
    <table align="center">
    <tr valign="baseline">
    <td nowrap align="right">Player:</td>
    <td><select name="StaPlayerID">
    <%
    While (NOT BPlayers.EOF)
    %>
    <option
    value="<%=(BPlayers.Fields.Item("PlayerID").Value) %>"><%=(BPlayers.Fields.Item("PlayerName").Value)% ></option>
    <%
    BPlayers.MoveNext()
    Wend
    If (BPlayers.CursorType > 0) Then
    BPlayers.MoveFirst
    Else
    BPlayers.Requery
    End If
    %>
    </select>
    </td>
    </tr>
    <tr valign="baseline">
    <td nowrap align="right">Date:</td>
    <td><select name="StaGameID">
    <%
    While (NOT BGamestats.EOF)
    %>
    <option
    value="<%=(BGamestats.Fields.Item("GameID").Value) %>"><%=(BGamestats.Fields.Item("Gameday").Value)%> </option>
    <%
    BGamestats.MoveNext()
    Wend
    If (BGamestats.CursorType > 0) Then
    BGamestats.MoveFirst
    Else
    BGamestats.Requery
    End If
    %>
    </select>
    </td>
    </tr>
    <tr valign="baseline">
    <td nowrap align="right">Goals:</td>
    <td><input type="text" name="StaGoals" value="" size="32">
    </td>
    </tr>
    <tr valign="baseline">
    <td nowrap align="right">Assists:</td>
    <td><input type="text" name="StaAssists" value="" size="32">
    </td>
    </tr>
    <tr valign="baseline">
    <td nowrap align="right">Points:</td>
    <td><input type="text" name="StaPoints" value="" size="32">
    </td>
    </tr>
    <tr valign="baseline">
    <td nowrap align="right">PIMS:</td>
    <td><input type="text" name="StaPIMS" value="" size="32">
    </td>
    </tr>
    <tr valign="baseline">
    <td nowrap align="right">&nbsp;</td>
    <td><input type="submit" value="Insert record">
    </td>
    </tr>
    </table>
    <input type="hidden" name="MM_insert" value="form1">
    </form>

    THanks for reading


    "McKirahan" <com> wrote in message
    news:Ll%bd.398126$.. 
    > direction? 
    > Smith 
    >
    > "whenever I try to update the table from the form I created in
    > dreamweaver,
    > it overwrites the other entries." is like saying "Doctor, something hurts,
    > can you cure me?".
    >
    > We can't fix what we can't see -- show us your code!
    >
    >[/ref]


    Whodat Guest

  4. #4

    Default Re: Sports DB

    "Whodat" <com> wrote in message
    news:520cd.3982$cgocable.net... 
    evaluated. 
    elements. 
    been 
    to 
    value="<%=(BPlayers.Fields.Item("PlayerID").Value) %>"><%=(BPlayers.Fields.It
    em("PlayerName").Value)%></option> 
    value="<%=(BGamestats.Fields.Item("GameID").Value) %>"><%=(BGamestats.Fields.
    Item("Gameday").Value)%></option> 

    [snip]

    1) Please do not top post.

    2) Where's your SQL statement?

    3) Here's a single ASP page that does what you originally asked.
    Basically, it display all Players and allows for each to be updated or a new
    Player to be added. However, it is up to you to compute and enter the new t
    otal number of "goals" etc. One thing missing is client-side data
    validation in the JavaScript function.

    Perhaps this will give you some ideas; let me know. Watch for word.wrap.


    <% Language="VBScript" %>
    <% Option Explicit

    '---------------------------------------------------------------------------
    '
    ' "players.asp"
    '
    ' This ASP (Active Server Pages) program does the following:
    ' 1) Displays the "players" table and allows add and update.
    '
    ' playerid (primary, autonumber)
    ' playername
    ' goals
    ' assists
    ' points
    ' pims
    ' shutouts
    '
    ' Test URL: http://localhost/players.asp
    '
    ' Changes:


    -------------------------------------------------------------------------
    ' 15-Oct-2004.0 Created.
    '

    '---------------------------------------------------------------------------
    '
    '*
    '* Declare Constants
    '*
    Const cASP = "players.asp"
    Const cMDB = "players.mdb"
    Const cDSN = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
    '*
    Const adCmdTable = &H0002
    Const adLockOptimistic = 3
    Const adOpenKeySet = 1
    '*
    '* Declare Variables
    '*
    Dim strPID
    strPID = Request.Form("playerid")
    Dim strSQL
    Dim arrSTR()
    ReDim arrSTR(100)
    Dim intSTR
    intSTR = 0
    Dim strSTR
    '*
    '* Declare Objects
    '*
    Dim objADO
    Set objADO = Server.CreateObject("ADODB.Connection")
    objADO.Open cDSN & Server.MapPath(cMDB)
    Dim objRST
    Set objRST = Server.CreateObject("ADODB.Recordset")
    '*
    '* SQL based on "playerid"
    '*
    If strPID = "0" Then
    '*
    '* ADDNEW
    '*
    objRST.Open "players", objADO, adOpenKeySet, adLockOptimistic,
    adCmdTable
    objRST.AddNew
    objRST("playername") = Request.Form("playername")
    objRST("goals") = CInt(Request.Form("goals"))
    objRST("assists") = CInt(Request.Form("assists"))
    objRST("points") = CInt(Request.Form("points"))
    objRST("pims") = CInt(Request.Form("pims"))
    objRST("shutouts") = CInt(Request.Form("shutouts"))
    objRST.Update
    objRST.Close
    ElseIf strPID <> "" Then
    '*
    '* UPDATE
    '*
    strSQL = "UPDATE players SET"
    strSQL = strSQL & " playername = '" & Request.Form("playername") &
    "'"
    strSQL = strSQL & ", goals = " & CInt(Request.Form("goals"))
    strSQL = strSQL & ", assists = " & CInt(Request.Form("assists"))
    strSQL = strSQL & ", points = " & CInt(Request.Form("points"))
    strSQL = strSQL & ", pims = " & CInt(Request.Form("pims"))
    strSQL = strSQL & ", shutouts = " & CInt(Request.Form("shutouts"))
    strSQL = strSQL & " WHERE playerid = " &
    CInt(Request.Form("playerid"))
    objADO.Execute(strSQL)
    End If
    '*
    '* SELECT
    '*
    strSQL = "SELECT * FROM players"
    strSQL = strSQL & " ORDER BY playername"
    objRST.Open strSQL, objADO
    Append "<table border='0' cellpadding='0' cellspacing='0'>"
    Append "<tr>"
    Append " <th>ID<hr></th>"
    Append " <th>&nbsp;<hr></th>"
    Append " <th>Player<hr></th>"
    Append " <th>Goals<hr></th>"
    Append " <th>Assists<hr></th>"
    Append " <th>Points<hr></th>"
    Append " <th>Pims<hr></th>"
    Append " <th>Shutouts<hr></th>"
    Append "<tr>"
    Append "<tr valign='top'>"
    Append " <td><input type='button' class='but2' value='0'
    onclick='player(0)'></td>"
    Append " <td>&nbsp;</td>"
    Append " <td><input type='text' class='left' size='20' name='pl0'
    value=''></td>"
    Append " <td><input type='text' class='rite' size='5' name='go0'
    value=''></td>"
    Append " <td><input type='text' class='rite' size='5' name='as0'
    value=''></td>"
    Append " <td><input type='text' class='rite' size='5' name='po0'
    value=''></td>"
    Append " <td><input type='text' class='rite' size='5' name='pi0'
    value=''></td>"
    Append " <td><input type='text' class='rite' size='5' name='sh0'
    value=''></td>"
    Append "<tr>"
    Do While Not objRST.EOF
    Append "<tr valign='top'>"
    Append " <td><input type='button' class='but2' value='" &
    objRST("playerid") & "' onclick='player(" & objRST("playerid") & ")'></td>"
    Append " <td>&nbsp;</td>"
    Append " <td><input type='text' class='left' size='20' name='pl" &
    objRST("playerid") & "' value='" & objRST("playername") & "'></td>"
    Append " <td><input type='text' class='rite' size='5' name='go" &
    objRST("playerid") & "' value='" & objRST("goals") & "'></td>"
    Append " <td><input type='text' class='rite' size='5' name='as" &
    objRST("playerid") & "' value='" & objRST("assists") & "'></td>"
    Append " <td><input type='text' class='rite' size='5' name='po" &
    objRST("playerid") & "' value='" & objRST("points") & "'></td>"
    Append " <td><input type='text' class='rite' size='5' name='pi" &
    objRST("playerid") & "' value='" & objRST("pims") & "'></td>"
    Append " <td><input type='text' class='rite' size='5' name='sh" &
    objRST("playerid") & "' value='" & objRST("shutouts") & "'></td>"
    Append "<tr>"
    objRST.MoveNext
    Loop
    objRST.Close
    Append "</table>"
    '*
    '* Destroy Objects
    '*
    Set objRST = Nothing
    objADO.Close
    Set objADO = Nothing

    Sub Append(strSTR)
    '** ------------------------------------------------------------------------
    ---'
    '* Append()
    '*
    '* Appends strings to array entries redimensioning as needed; (see
    "Concat()").
    '** ------------------------------------------------------------------------
    ---'
    strSTR = strSTR & ""
    If intSTR > UBound(arrSTR) Then
    ReDim Preserve arrSTR(UBound(arrSTR) + 100)
    End If
    arrSTR(intSTR) = strSTR & vbCrLf
    intSTR = intSTR + 1
    End Sub

    Function Concat()
    '** ------------------------------------------------------------------------
    ---'
    '* Concat()
    '*
    '* Concatenates array entries into a single string; (see "Append()").
    '** ------------------------------------------------------------------------
    ---'
    Redim Preserve arrSTR(intSTR)
    Concat = Replace(Join(arrSTR, ""),"`",Chr(34))
    Erase arrSTR
    ReDim arrSTR(100)
    intSTR = 0
    End Function
    %>
    <html>
    <head>
    <title><%=cASP%></title>
    <script type="text/javascript">
    function player(id) {
    var pl = doent.getElementById("pl"+id).value;
    var go = doent.getElementById("go"+id).value;
    var as = doent.getElementById("as"+id).value;
    var po = doent.getElementById("po"+id).value;
    var pi = doent.getElementById("pi"+id).value;
    var sh = doent.getElementById("sh"+id).value;
    // insert validation logic here; ensure numbers are numeric, etc.
    var f1 = doent.form1;
    f1.playerid.value = id;
    f1.playername.value = pl;
    f1.goals.value = go;
    f1.assists.value = as;
    f1.points.value = po;
    f1.pims.value = pi;
    f1.shutouts.value = sh;
    f1.submit();
    }
    </script>
    <style type="text/css">
    body { font-family:Arial,Helvetica; font-size:10pt }
    td { font-family:Arial,Helvetica; font-size:10pt }
    th { font-family:Arial,Helvetica; font-size:10pt; font-weight:bold }
    ..but1 { font-family:Arial,Helvetica; font-size:8pt; width:40; height:20 }
    ..but2 { font-family:Arial,Helvetica; font-size:8pt; width:30; height:20 }
    ..left { font-family:Arial,Helvetica; font-size:8pt; height:20;
    text-align:left }
    ..rite { font-family:Arial,Helvetica; font-size:8pt; height:20;
    text-align:right }
    </style>
    </head>
    <body>
    <form action="<%=cASP%>" method="post" name="form1">
    <input type="hidden" name="playerid" value="">
    <input type="hidden" name="playername" value="">
    <input type="hidden" name="goals" value="0">
    <input type="hidden" name="assists" value="0">
    <input type="hidden" name="points" value="0">
    <input type="hidden" name="pims" value="0">
    <input type="hidden" name="shutouts" value="0">
    <%=Concat()%>
    <input type="reset" value="Reset" class="but1">
    &nbsp; <b>ID buttons: click "0" to Add a Player else Update a Player</b>
    </form>
    </body>
    </html>


    McKirahan Guest

  5. #5

    Default Re: Sports DB


    "McKirahan" <com> wrote in message
    news:R51cd.247250$.. 
    > evaluated. 
    > elements. 
    > been 
    > to 
    > value="<%=(BPlayers.Fields.Item("PlayerID").Value) %>"><%=(BPlayers.Fields.It
    > em("PlayerName").Value)%></option> 
    > value="<%=(BGamestats.Fields.Item("GameID").Value) %>"><%=(BGamestats.Fields.
    > Item("Gameday").Value)%></option> 
    >
    > [snip]
    >
    > 1) Please do not top post.
    >
    > 2) Where's your SQL statement?
    >
    > 3) Here's a single ASP page that does what you originally asked.
    > Basically, it display all Players and allows for each to be updated or a
    > new
    > Player to be added. However, it is up to you to compute and enter the new
    > t
    > otal number of "goals" etc. One thing missing is client-side data
    > validation in the JavaScript function.
    >
    > Perhaps this will give you some ideas; let me know. Watch for word.wrap.
    >
    >
    > <% Language="VBScript" %>
    > <% Option Explicit
    >
    > '---------------------------------------------------------------------------
    > '
    > ' "players.asp"
    > '
    > ' This ASP (Active Server Pages) program does the following:
    > ' 1) Displays the "players" table and allows add and update.
    > '
    > ' playerid (primary, autonumber)
    > ' playername
    > ' goals
    > ' assists
    > ' points
    > ' pims
    > ' shutouts
    > '
    > ' Test URL: http://localhost/players.asp
    > '
    > ' Changes:
    >
    >
    > -------------------------------------------------------------------------
    > ' 15-Oct-2004.0 Created.
    > '
    >
    > '---------------------------------------------------------------------------
    > '
    > '*
    > '* Declare Constants
    > '*
    > Const cASP = "players.asp"
    > Const cMDB = "players.mdb"
    > Const cDSN = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
    > '*
    > Const adCmdTable = &H0002
    > Const adLockOptimistic = 3
    > Const adOpenKeySet = 1
    > '*
    > '* Declare Variables
    > '*
    > Dim strPID
    > strPID = Request.Form("playerid")
    > Dim strSQL
    > Dim arrSTR()
    > ReDim arrSTR(100)
    > Dim intSTR
    > intSTR = 0
    > Dim strSTR
    > '*
    > '* Declare Objects
    > '*
    > Dim objADO
    > Set objADO = Server.CreateObject("ADODB.Connection")
    > objADO.Open cDSN & Server.MapPath(cMDB)
    > Dim objRST
    > Set objRST = Server.CreateObject("ADODB.Recordset")
    > '*
    > '* SQL based on "playerid"
    > '*
    > If strPID = "0" Then
    > '*
    > '* ADDNEW
    > '*
    > objRST.Open "players", objADO, adOpenKeySet, adLockOptimistic,
    > adCmdTable
    > objRST.AddNew
    > objRST("playername") = Request.Form("playername")
    > objRST("goals") = CInt(Request.Form("goals"))
    > objRST("assists") = CInt(Request.Form("assists"))
    > objRST("points") = CInt(Request.Form("points"))
    > objRST("pims") = CInt(Request.Form("pims"))
    > objRST("shutouts") = CInt(Request.Form("shutouts"))
    > objRST.Update
    > objRST.Close
    > ElseIf strPID <> "" Then
    > '*
    > '* UPDATE
    > '*
    > strSQL = "UPDATE players SET"
    > strSQL = strSQL & " playername = '" & Request.Form("playername") &
    > "'"
    > strSQL = strSQL & ", goals = " & CInt(Request.Form("goals"))
    > strSQL = strSQL & ", assists = " & CInt(Request.Form("assists"))
    > strSQL = strSQL & ", points = " & CInt(Request.Form("points"))
    > strSQL = strSQL & ", pims = " & CInt(Request.Form("pims"))
    > strSQL = strSQL & ", shutouts = " & CInt(Request.Form("shutouts"))
    > strSQL = strSQL & " WHERE playerid = " &
    > CInt(Request.Form("playerid"))
    > objADO.Execute(strSQL)
    > End If
    > '*
    > '* SELECT
    > '*
    > strSQL = "SELECT * FROM players"
    > strSQL = strSQL & " ORDER BY playername"
    > objRST.Open strSQL, objADO
    > Append "<table border='0' cellpadding='0' cellspacing='0'>"
    > Append "<tr>"
    > Append " <th>ID<hr></th>"
    > Append " <th>&nbsp;<hr></th>"
    > Append " <th>Player<hr></th>"
    > Append " <th>Goals<hr></th>"
    > Append " <th>Assists<hr></th>"
    > Append " <th>Points<hr></th>"
    > Append " <th>Pims<hr></th>"
    > Append " <th>Shutouts<hr></th>"
    > Append "<tr>"
    > Append "<tr valign='top'>"
    > Append " <td><input type='button' class='but2' value='0'
    > onclick='player(0)'></td>"
    > Append " <td>&nbsp;</td>"
    > Append " <td><input type='text' class='left' size='20' name='pl0'
    > value=''></td>"
    > Append " <td><input type='text' class='rite' size='5' name='go0'
    > value=''></td>"
    > Append " <td><input type='text' class='rite' size='5' name='as0'
    > value=''></td>"
    > Append " <td><input type='text' class='rite' size='5' name='po0'
    > value=''></td>"
    > Append " <td><input type='text' class='rite' size='5' name='pi0'
    > value=''></td>"
    > Append " <td><input type='text' class='rite' size='5' name='sh0'
    > value=''></td>"
    > Append "<tr>"
    > Do While Not objRST.EOF
    > Append "<tr valign='top'>"
    > Append " <td><input type='button' class='but2' value='" &
    > objRST("playerid") & "' onclick='player(" & objRST("playerid") &
    > ")'></td>"
    > Append " <td>&nbsp;</td>"
    > Append " <td><input type='text' class='left' size='20' name='pl" &
    > objRST("playerid") & "' value='" & objRST("playername") & "'></td>"
    > Append " <td><input type='text' class='rite' size='5' name='go" &
    > objRST("playerid") & "' value='" & objRST("goals") & "'></td>"
    > Append " <td><input type='text' class='rite' size='5' name='as" &
    > objRST("playerid") & "' value='" & objRST("assists") & "'></td>"
    > Append " <td><input type='text' class='rite' size='5' name='po" &
    > objRST("playerid") & "' value='" & objRST("points") & "'></td>"
    > Append " <td><input type='text' class='rite' size='5' name='pi" &
    > objRST("playerid") & "' value='" & objRST("pims") & "'></td>"
    > Append " <td><input type='text' class='rite' size='5' name='sh" &
    > objRST("playerid") & "' value='" & objRST("shutouts") & "'></td>"
    > Append "<tr>"
    > objRST.MoveNext
    > Loop
    > objRST.Close
    > Append "</table>"
    > '*
    > '* Destroy Objects
    > '*
    > Set objRST = Nothing
    > objADO.Close
    > Set objADO = Nothing
    >
    > Sub Append(strSTR)
    > '** ------------------------------------------------------------------------
    > ---'
    > '* Append()
    > '*
    > '* Appends strings to array entries redimensioning as needed; (see
    > "Concat()").
    > '** ------------------------------------------------------------------------
    > ---'
    > strSTR = strSTR & ""
    > If intSTR > UBound(arrSTR) Then
    > ReDim Preserve arrSTR(UBound(arrSTR) + 100)
    > End If
    > arrSTR(intSTR) = strSTR & vbCrLf
    > intSTR = intSTR + 1
    > End Sub
    >
    > Function Concat()
    > '** ------------------------------------------------------------------------
    > ---'
    > '* Concat()
    > '*
    > '* Concatenates array entries into a single string; (see "Append()").
    > '** ------------------------------------------------------------------------
    > ---'
    > Redim Preserve arrSTR(intSTR)
    > Concat = Replace(Join(arrSTR, ""),"`",Chr(34))
    > Erase arrSTR
    > ReDim arrSTR(100)
    > intSTR = 0
    > End Function
    > %>
    > <html>
    > <head>
    > <title><%=cASP%></title>
    > <script type="text/javascript">
    > function player(id) {
    > var pl = doent.getElementById("pl"+id).value;
    > var go = doent.getElementById("go"+id).value;
    > var as = doent.getElementById("as"+id).value;
    > var po = doent.getElementById("po"+id).value;
    > var pi = doent.getElementById("pi"+id).value;
    > var sh = doent.getElementById("sh"+id).value;
    > // insert validation logic here; ensure numbers are numeric, etc.
    > var f1 = doent.form1;
    > f1.playerid.value = id;
    > f1.playername.value = pl;
    > f1.goals.value = go;
    > f1.assists.value = as;
    > f1.points.value = po;
    > f1.pims.value = pi;
    > f1.shutouts.value = sh;
    > f1.submit();
    > }
    > </script>
    > <style type="text/css">
    > body { font-family:Arial,Helvetica; font-size:10pt }
    > td { font-family:Arial,Helvetica; font-size:10pt }
    > th { font-family:Arial,Helvetica; font-size:10pt; font-weight:bold }
    > .but1 { font-family:Arial,Helvetica; font-size:8pt; width:40; height:20 }
    > .but2 { font-family:Arial,Helvetica; font-size:8pt; width:30; height:20 }
    > .left { font-family:Arial,Helvetica; font-size:8pt; height:20;
    > text-align:left }
    > .rite { font-family:Arial,Helvetica; font-size:8pt; height:20;
    > text-align:right }
    > </style>
    > </head>
    > <body>
    > <form action="<%=cASP%>" method="post" name="form1">
    > <input type="hidden" name="playerid" value="">
    > <input type="hidden" name="playername" value="">
    > <input type="hidden" name="goals" value="0">
    > <input type="hidden" name="assists" value="0">
    > <input type="hidden" name="points" value="0">
    > <input type="hidden" name="pims" value="0">
    > <input type="hidden" name="shutouts" value="0">
    > <%=Concat()%>
    > <input type="reset" value="Reset" class="but1">
    > &nbsp; <b>ID buttons: click "0" to Add a Player else Update a Player</b>
    > </form>
    > </body>
    > </html>
    >
    >[/ref]
    Thanks very much for that. I have tried it out and it should give me a good
    base to go on thank you very much.

    I am away for 2 weeks starting on sunday so I will probably not be playing
    with it untill I return.

    Thanks again.


    Whodat Guest

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139