How to return the number of rows in php to test

Here is the code... how do i return the number of rows in query?

    $arr_Out = array();
    $result = $db->query("SELECT id,title,approve FROM dle_post");
    while ($row2 = $db->get_row($result)) {
        $title_id[$row2['id']] = stripslashes($row2['title']);
    }
    
$result = $db->query("SELECT * FROM dle_images RIGHT JOIN dle_post ON dle_images.news_id = dle_post.id where dle_post.approve = 1 ORDER BY RAND()  LIMIT 20");

Code (markup):

 

$result->num_rows();

 

Hi,

Thanks for the reply. Can you put that into code that works?

I get "Fatal error: Call to undefined function num_rows() "

Thanks,

Gibs

 

hello,
try
$x=mysql_num_rows($result);
echo $x;




regards =)
Mohie