> can I use limit to show the 2nd record on without knowing 
 > how many more records there might be?
 > also, what happens if I set the limit in a mysql statement 
 > (LIMIT 5,10), but there are only 3 results? 7 results?

My answer would tend to be that you should try it for yourself and

But anyway, without having tried it myself recently, the first question
is that you could use LIMIT (2, 1) and you'd probably get what you're
trying for.  As for the second question, you'll only get what records
there are.  If your limit excludes all possible results then you'll get
no result (ie. If you use LIMIT(5, 10) and you've only got 3 records,
then you won't get anything back at all.  If you've got 7 records then
you'll get the last 3 of them).  But in all honesty, you could have
worked this out for yourself fairly quickly with some simple testing of
your own.

CYA, Dave

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to