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

Reply via email to