returning json_encode

[ThrowsException]

Hey everyone I was hoping someone could help solve a problem where I'm trying to return a query using json_encode. I'm using the MVC tutorial on the site and trying to use the direct classes. my query looks like this

$rows = array();
        while ($row = mysql_fetch_assoc($result)) {
            $rows[] = $row;
        }
        $data = json_encode($rows);
        return array(
            'data' => $data
        );

and my store looks like

Ext.define('Application.store.Scorecards',{
    extend: 'Ext.data.Store',
    model: 'Application.model.Scorecard',
    autoLoad: true,
    proxy: {
        type: 'direct',
        directFn: Ext.emptyFn,
        reader: {
            type: 'json',
            root: 'data',
        }
    }
});

and my model

// JavaScript Document
Ext.define('Application.model.Scorecard' ,{
    extend: 'Ext.data.Model',
    fields: ['Id','Name','Owners'],
    validations: [{
        type: 'length',
        field: 'Name',
        min: 1
    }, {
        type: 'length',
        field: 'Owners',
        min: 1
    }], 
});

when I run the app I just get a grid with a bunch of empty rows and my router class returns this

[{"type":"rpc","tid":1,"action":"Scorecard","method":"getScorecards","result":{"data":"[{\"Id\":\"1\",\"Name\":\"First Scorecard\",\"Owners\":\"Me\"}]"}},{"type":"rpc","tid":2,"action":"Scorecard","method":"getScorecards","result":{"data":"[{\"Id\":\"1\",\"Name\":\"First Scorecard\",\"Owners\":\"Me\"}]"}}]

[ThrowsException]

So I'm working on this more now and I notice the JSON object my router returns is

"{"Id":"1","Name":"First Scorecard","Owners":"Me"}"

Thats the entry that is in the 'data' array that comes back.

However I noticed some tutorials the JSON returned inside the array looks like

Object {id=1, name="John Doe", email="john@doe.com", ...}

Instead of a bunch of blank rows I'm now getting the correct number of rows, 1 in this case, but it's still blank.

[ThrowsException]

so instead of trying to use Json_encode and having no luck I just changed my query to this.

$rows = array();
while ($row = mysql_fetch_assoc($result)) {
        $rows[] = array('Id' => $row["Id"],
                            'Name' => $row["Name"],
                            'Owners' => $row["Owners"]);
        }
        return array(
            'data' =>  $rows,
            'success' => TRUE
        );

So its working now I just feel like there's a better way to do it. If anyone has any improvements and ideas feel free to share.

[campersau1]

I think that should work:

$rows = array();
while ($row = mysql_fetch_assoc($result)) {
  $rows[] = $row;
}
return array(
  'data' =>  $rows,
  'success' => TRUE
);

havent't programmed in php for quite some time.