<% Amount = Request.Form("txtamount") IDno = request.Form("optsel") SelectOption= request.Form("optsel") 'Build connection with database set conn = server.CreateObject ("ADODB.Connection") 'conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("users.mdb") Conn.Open "DSN=Transaction" set rs = server.CreateObject ("ADODB.Recordset") 'Open record with entered username 'rs.Open "SELECT ID, username , Amount FROM Table1 where ID='"& IDno &"'", conn, 1 'If there is no record with the entered id, close connection 'and go back to balance with QueryString responce.write("thank you") %>
1: its the thanks page after the user sign in successfully !
1: how can i select the person from database and display his balance in the above page in table in detail he entered except password!
2: i have tried 6 days but failed to make the transaction page ! simple if the user enter the amount and transfer it.
first it will be checked if the user have that much balance or not if yes than transfer the money to other account enter id number else show the sorry page