CODEWITHSUNDEEP
phpmysql
Kevin
Kevin

Reputation: 23634

Return Total Rows from a table

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.

Upvotes: 0

Views: 119

Answers (2)

Quang Hai
Quang Hai

Reputation: 11

You can use function count($array) in php

Upvotes: 0

ianbarker
ianbarker

Reputation: 1253

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

Upvotes: 1

Related Questions