从表中返回总行数

Question

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>";
}

My 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

Can i return the number of rows in table like this, i am getting XML markup error.

Answer 1

$output .= $row=mysql_fetch_array($result) will output Array maybe you want $output .= mysql_num_rows($result);?