kloon_za
05-14-2008, 08:36 AM
Hi I would like to find a position based on a integer. So there are a few records in a db for the same track, and each user that races on the track get a entry into table with userId and time in miliseconds. Now I need a query with userId in where clause thats calculates the positions based on time in miliseconds agains other users with same trackid.
Fields in the records table is Id, ChallengeId, PlayerId, Score
So if i put in userId = 1 in where it must find the Score position of that user's score agains the other users with same ChallengeId.
Fields in the records table is Id, ChallengeId, PlayerId, Score
So if i put in userId = 1 in where it must find the Score position of that user's score agains the other users with same ChallengeId.