Thanks Simon.
I have a further question on this topic. I would like to find out where my user ranks amongst all scores - so I want to SELECT name, score FROM scoreTable WHERE id=x And then I wish to know how many rows occur before the one where user=myuser. I can loop through them in code, but it seems like this is intermediate data SQLite might be able to get quicker? On 18/10/2010 16:12, Simon Slavin wrote: > On 18 Oct 2010, at 4:09pm, Ian Hardingham wrote: > >> I also want to add selecting the highest score, and adding it to the >> results assuming it isn't already in there (ie unless it happens your or >> a friends' score is the highest). Could anyone advise me on how best to >> do that? > Can you not do this in whatever programming language you use ? SQL is only a > database language. It's not really intended for all these conditions and > calculations. You will get faster results, and easier to debug text if you > can write it in whatever language you're using. > > Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
