Results Returned Issue

[ainoy31]

Hello-

 

I have the following query and it is not returning the right total rows found. 

$sql = "SELECT j.* FROM jobber_weight_and_dims as j LEFT JOIN product as p on p.brushed = j.part_number AND p.polished = j.part_number AND p.allblack = j.part_number AND p.type = 'Marque Mesh'";
$result = mysql_query($sql) or die("Error: " . mysql_error());


$row = mysql_fetch_array($result) or die("Error: " . mysql_error());
echo count($row);

 

The return counted rows is 26.  However, if you check it in MyphpAdmin, the total return of rows should be 1044.  Much appreciation.  AM