php code for counting records (mysql_num_rows) -->

I'm coding a little admin mod and I'm having some trouble.. thought maybe a guru here could help.

I'm not that used to dealing with classes, but here's a simplified example of my code

$sql = "SOME SQL STATEMENT";
$get_list = $db->Execute($sql);
if($get_list->RecordCount() > 0) {
    while(!$get_list->EOF) {
        // do something
        $get_list->MoveNext();
    }
} else {
    echo "no records were found";
}

I get an error that RecordCount() is an undefined function... but I'm pretty sure that's the function in the query_factory.php file

Should I use another function to get the number of rows returned with my query?

can u post the exact error message as it appears in the browser ?

Fatal error: Call to a member function on a non-object

The line it specifies has this code - if($get_list->RecordCount() > 0) {

If you use $db inside a function, remember to declare it global.
Also, run that sql statement you have directly on phpmyadmin, see if it generates the result you expected.

on the page this is running on have you got an includes/require for application_top.php

I found an error in my code. The example I posted works fine. But in coding my script, I missed something small and vitally important... always some stupid little thing.

Anyways, hopefully someone else who needs this question answered in the future can benefit from the post ;)

Thanks for the help all.