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