getting objects from array of database results

[silphium]

How do I access objects inside an array of database results? I have a method that returns MySQL results as an array "$projects". Running print_r($projects) gives me this:

 

array(1) (

    "projects" => object Database_MySQL_Result(6) {

        protected _internal_row => integer 0

        protected _query => string(875) "SELECT [skipping remainder of long query]"

        protected _result => resource(mysql result)

        protected _total_rows => integer 53

        protected _current_row => integer 0

        protected _as_object => string(13) "Model_Project"

    }

)

 

If I do this: foreach($projects as $project)

{

echo $project->PROJECT_NAME;

}

 

I get "Undefined property: Database_MySQL_Result::$PROJECT_NAME"

 

If I do this:

 

foreach($projects as $project)

{

echo $project[0];

}

 

the browser will display projects.id for the first returned row *only*

 

echo $project[1] returns the project.id for the second row only. And so on.

 

Each returned row contains over a dozen cells.

 

It's almost as if I'm referring to the array incorrectly, or referring to the wrong array. I feel as though I'm making a very simple (and perhaps dumb) mistake here, but can't quite figure out what it is. Thanks.