*progr_no* *ID* 1 grace *2* *john* 3 alan 4 tim *5* *john* *6* *john* 7 sandra *8* *john*
What is the simplest and most efficient way of telling SQLITE to select the NEXT or the PREVIOUS *progr_no *for a given recurring ID, let's say "john"? Let's assume that I currently I am at progr_no=5. I was thinking of maybe looping for a given ID and building an associative array with also the progr_no, but there must be a more efficient and direct solution, I guess! Cheers Ed _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users