mysql query and json output for bootgrid

<?php
mysql_select_db($database_vetonline, $vetonline);
$query_beneficiaries = "SELECT fullnames.`Full Name`, studentdetails.StudentID, studentdetails.Gender, coursedetails.CourseType, lt_coursedescription.CourseDescriptionLong, lt_coursedescription.CourseDescriptionShort, scholarshipdetails.ScholarshipYear, tuitionfeedetails.PrevSemYear, tuitionfeedetails.CurrSemYear, tuitionfeedetails.FeePerSemYear, tuitionfeedetails.FeePaidByStudent, tuitionfeedetails.FeePaidForSemYear, scholarshipdetails.FeeAmountApproved, Sum(scholarshipdetails.HeldDeposit), Sum(scholarshipdetails.ScholarshipAwarded), scholarshipdetails.DepositStatus, scholarshipdetails.ScholarshipStatus, lt_cities.CityName, lt_coursesubject.`Subject`, studentdetails.StudentID FROM studentdetails INNER JOIN scholarshipdetails ON studentdetails.StudentID = scholarshipdetails.StudentID INNER JOIN coursedetails ON studentdetails.StudentID = coursedetails.StudentID AND scholarshipdetails.ScholarshipYear = coursedetails.Scholarshipyear LEFT JOIN lt_coursedescription ON coursedetails.CourseDescriptionID = lt_coursedescription.CourseDescriptionID INNER JOIN tuitionfeedetails ON studentdetails.StudentID = tuitionfeedetails.StudentID AND scholarshipdetails.ScholarshipYear = tuitionfeedetails.ScholarshipYear INNER JOIN fullnames ON studentdetails.StudentID = fullnames.StudentID INNER JOIN lt_cities ON lt_cities.CityID = studentdetails.City LEFT JOIN lt_coursesubject ON lt_coursesubject.CourseDescriptionID = lt_coursedescription.CourseDescriptionID AND lt_coursesubject.SubjectID = coursedetails.CourseSubject GROUP BY studentdetails.StudentID";
$beneficiaries = mysql_query($query_beneficiaries, $vetonline) or die(mysql_error());
$resultarray = array();
while($row_beneficiaries = mysql_fetch_assoc($beneficiaries))
{
    $resultarray[] = $row_beneficiaries;
};
$totalRows_beneficiaries = mysql_num_rows($beneficiaries);

echo json_encode($resultarray);
?>

<?php
mysql_free_result($beneficiaries);
?>