In short, it would be "LIMIT 20,0" If I'm not mistaken. However, the db isn't going to kick out the string "The query returned 0-20 of 132 records" for you.
Are you trying to do database pagination? Mulitple rows spread across multiple page views? If that's the case, PHPBuilder has an article on the topic. Also, if you are OK with using objects, I wrote one for that specific purpose. Let me know, TRC ----- Original Message ----- From: [EMAIL PROTECTED] Date: Thu, 30 May 2002 14:24:58 -0400 To: [EMAIL PROTECTED] Subject: count...I think Hey guys, I have a very simple question, I though I knew the answer but the MySql manual has confused me.... I have a simple select from a database of say.......1k records...I use select id from myTable where sal>1000; Lets say this statement would normally return 132 records, but how do I know how many it will return? Basically I want it to return "The query returned 0-20 of 132 records" (I am using PHP) I know theres a "count" somewhere....but where? Cheers, -Ryan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- _______________________________________________ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
