What do I replace the depreciated mysql_num_rows with ?

[jeddi]

Hi,

I quite often use :

PHP Code:

$sql = "SELECT page_id,page_type,cat_cd FROM pages WHERE assigned = 'n' ";
$result = mysql_query($sql)    or die("could not find SITE: $site_id". mysql_error());
$num = mysql_num_rows($result);

if ($num > 0 ) { 


I just noticed that the Manual says "mysql_num_rows - This extension is deprecated as of PHP 5.5.0"

I write php in procedural style rather than OOP.

What should I use instead of
$num = mysql_num_rows($result);

Thanks


.

[sunfighter]

This page in the manual: http://www.php.net/manual/en/mysqli-stmt.num-rows.php

[Fou-Lu]

That one would be for statements, while from result you can use mysqli_num_rows. So it depends on if you are preparing a statement or querying directly.
I should note that since there are two functions and you could do either statements or direct querying, you'd be better of using either the statement's get_result and pulling the mysqli_num_rows off of that, or even better, simply sticking to object oriented as both mysqli_stmt and mysqli_result contain a num_rows property on them.

[Dormilich]

depending on the case, SQL’s COUNT() function can be used to avoid the PHP row counting alltogether.