note 90412 added to function.msql-num-rows

If you would like to just find out how many rows are returned by a query without actually using the results, then it's much more efficient to use SQL count function (specially for large tables with millions of rows). <?php $sql = "SELECT COUNT(indexed-field) AS cnt FROM some-table"; $r = mysql_query($sql); $row = mysql_fetch_object($r); echo $row->cnt; ---- Server IP: 209.41.74.194 Probable Submitter: 68.183.50.140 ---- Manual Page -- http://www.php.net/manual/en/function.msql-num-rows.php Edit -- https://master.php.net/note/edit/90412 Del: integrated -- https://master.php.net/note/delete/90412/integrated Del: useless -- https://master.php.net/note/delete/90412/useless Del: bad code -- https://master.php.net/note/delete/90412/bad+code Del: spam -- https://master.php.net/note/delete/90412/spam Del: non-english -- https://master.php.net/note/delete/90412/non-english Del: in docs -- https://master.php.net/note/delete/90412/in+docs Del: other reasons-- https://master.php.net/note/delete/90412 Reject -- https://master.php.net/note/reject/90412 Search -- https://master.php.net/manage/user-notes.php