note 83424 added to function.mysql-num-rows

The following code can wrap it all up in a single query so you don't have to worry about multiple client requests: $stmtMain = $mysqli->prepare("SELECT SQL_CALC_FOUND_ROWS jobid,title FROM tbljobs LIMIT ?, ? UNION SELECT FOUND_ROWS(),'!!IgnoreCount!!';") Then iterate through the results with something like: while ($stmtMain->fetch() && $strResultTitle !="!!IgnoreCount!!") { //do stuff } ($strResultSector == '!!IgnoreCount!!')? $intTotal = $intResultCount : 1; ---- Server IP: 92.48.100.16 Probable Submitter: 78.86.138.128 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-num-rows.php Edit -- https://master.php.net/note/edit/83424 Del: integrated -- https://master.php.net/note/delete/83424/integrated Del: useless -- https://master.php.net/note/delete/83424/useless Del: bad code -- https://master.php.net/note/delete/83424/bad+code Del: spam -- https://master.php.net/note/delete/83424/spam Del: non-english -- https://master.php.net/note/delete/83424/non-english Del: in docs -- https://master.php.net/note/delete/83424/in+docs Del: other reasons-- https://master.php.net/note/delete/83424 Reject -- https://master.php.net/note/reject/83424 Search -- https://master.php.net/manage/user-notes.php