while($row=mysql_fetch_array($result))
{
    $output .= "<Reports>";

    $output .= "<ProjectName>";
    $output .= $row['ProjectName'];
    $output .= "</ProjectName>";

    $output .= "<ProjectCount>";
    $output .= $row=mysql_fetch_array($result)
    $output .= "</ProjectCount>";

    $output .= "</Reports>";
}

Benim SQL Query.

SELECT designation.desg_Name AS PM, project.ProjectName,
Case ProjectPhase.PhaseID WHEN 1 THEN 'ScopeofWork' END AS ScopeofWork,
Case ProjectPhase.PhaseID WHEN 2 THEN 'DesignDocument' END AS DesignDocument,
Case ProjectPhase.PhaseID WHEN 3 THEN 'Storyboard' END AS Storyboard,
Case ProjectPhase.PhaseID WHEN 4 THEN 'Alpha' END AS Alpha,
Case ProjectPhase.PhaseID WHEN 5 THEN 'Beta' END AS Beta,
Case ProjectPhase.PhaseID WHEN 6 THEN 'Gold' END AS Gold,
Case ProjectPhase.PhaseID WHEN 7 THEN 'TE Storyboard review' END AS 'TE Storyboard review'
FROM `tycodashboard` t JOIN project ON project.projectID = t.projectID
JOIN projectPhase ON projectPhase.PhaseID = t.PhaseID
JOIN designation ON designation.designationID = t.designationID

Ben böyle tablodaki satır sayısını dönebilirsiniz, ben XML işaretleme hatası alıyorum.