On Fri, Jul 17, 2009 at 9:35 AM, PJ<af.gour...@videotron.ca> wrote: > 4. when ordering by title, results are totally different for ASC & DESC; > not the same data at all (Is the ordering done on the entire db? )
Yes, sort of. ORDER BY is applied to the results of the entire query. Then LIMIT takes a slice out of the results (paginate). My guess, the "problem" you are experiencing is you are viewing page 2 of 5 of your output in ASC order, then switch over to DESC without adjusting the page number. What you are seeing (roughly) for page 2 of 5 in DESC order is what used to be on page 4 of 5 in ASC order, only "upside-down". :-) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
