Doing, that's why you use LIMIT.However, one more thing. I believe if you fetch all of the data first, MySQL or the database sends it all back to PHP, which can be a huge chunk. That chunk has to be processed and go through the pipeline to the server PHP is on (if they are separate servers). I'm probably talking out my ass, but other methods PHP calls for the first row and MySQL sends just that row and then moves the counter up to send the next row that meets the criteria.
So it breaks down to sending all of the data at once or just a tiny bit at a time. You will eventually fetch all of the data, but if you so happen that you don't need to go any further after say row 1000 out of a million, then you saved yourself a lot of data that would have otherwise had been sent.
Teehee, I was wondering that too. But it doesn't hurt (unless you accidentally click it).No One uses Reset Anymore
No need for JavaScript, but I forgot that you need the link to the register page. That's another configuration thing.How about a Register button instead that transfers to another page (using JavaScript?) that will allow them to register.
I agree with everything else you said. I've actually got more notes, but they're not typed up yet.