1 reputation
2
bio website
location
age
visits member for 1 year, 10 months
seen Dec 5 '12 at 22:13

Dec
5
awarded  Commentator
Dec
5
comment Grabbing data from a query with specific criteria, then the data around it
Ok... although If that works the same way the name did... that would still run into the same issue the name's did.
Dec
5
comment Grabbing data from a query with specific criteria, then the data around it
Wouldn't that still run into the issue of it would sort it based on user id and not only kills? Thus messing up the purely kill ranking?
Dec
5
comment Grabbing data from a query with specific criteria, then the data around it
Issue with using the name to compare it: If they have similar names, it will select ones with names like the first one: eg if the name contains super.. SuperBob,SuperMario, ETC. will selectpeople with name's beginning with super. So, is it possible to make a temporary variable to sort them by that is literal rank, or something else we could use to limit it to only 11, other than name, because name doesn't work if people have similar names, which in a table of 123k rows, is bound to happen. Alot.
Dec
5
comment Grabbing data from a query with specific criteria, then the data around it
Well, is there a way to prevent it from giving more than is applicable if people have the same # of kills? like if 1000 people have 0 kills, i need it to not end up spitting out 1000 entries.
Dec
5
comment Grabbing data from a query with specific criteria, then the data around it
Should it prevent the duplicates now? :)
Dec
5
comment Grabbing data from a query with specific criteria, then the data around it
Alot of users have 0-10 kills.. is it possible at all to prevent a massive # of duplicates showing up, because if the user has the same # of kills as about 100 of the other 123k people, it could lead to an issue.
Dec
4
comment Grabbing data from a query with specific criteria, then the data around it
Yes, name is unique. No two people in it have the same name.
Dec
4
comment Grabbing data from a query with specific criteria, then the data around it
The query I added doesn't work because it lists large numbers of users when it should only list 5. :/
Dec
4
revised Grabbing data from a query with specific criteria, then the data around it
added 258 characters in body
Dec
4
awarded  Editor
Dec
4
revised Grabbing data from a query with specific criteria, then the data around it
added 655 characters in body
Dec
4
comment Grabbing data from a query with specific criteria, then the data around it
Yes. That is what I wanted, and I'll post the query I currently have, which does a full table scan and takes for ever in addition to not providing a window in the question.
Dec
4
comment Grabbing data from a query with specific criteria, then the data around it
@dezso - i can post the query I was using in the question if need be. I tried it with it, and it eventually gave up after a very long time and loaded alot more rows than it should've.
Dec
4
asked Grabbing data from a query with specific criteria, then the data around it