Getting Count Result

[Anon]

$sql = "select count(), SUBSTRING(SUBSTRING_INDEX(category, '|', 2), 2) 1
AS sortdata from records where title = '$titles' AND active = '1'
GROUP by sortdata ASC";

$result = mysql_query($sql);

$rows = mysql_num_rows($result);

$click = 1;

for ($row = 0; $row < $rows; $row++)
{
$sortdata = mysql_result($result,$row,"sortdata");

echo "sort data ( NUMBER FROM COUNT )";
}