Login -User Validation/ Verification Scritp

1 table that has 4 fields -TransID -Used -Date -IP an admin form -that allows me to enter TRANSIDs into the table a user form that asks for transaction ID -- check to see if USER ID exists if it doesnt - prompt it does not exist if the ID exists - Used is checked for true of false IF false the user is prompted if they want to USE the ID If they say yes -- the value of Used is set to TRUE, datestamped and IP stamp added and they are redirected to a new URL IF True then promted that this ID has already been used It would be nice to be able to have a query just show all the data results of the table Should be a simple job - You can probably have this done in 10 minutes if you have a login script. I have MSSQL and not MYSQL XML is fine if you want to use that. code can be php, asp or asp.net