<?php

$query = "SELECT * FROM complaints";
$queryRun = mysql_query($query);
$numRows = mysql_num_rows($queryRun);

$solved = mysql_query("SELECT * FROM complaints WHERE solved = 1");
$numNows2 = mysql_num_rows($solved);

$noSolved = mysql_query("SELECT * FROM complaints WHERE solved = 0");
$numNows3 = mysql_num_rows($noSolved);


echo 'Complaints: '.$numRows.'<br />';
echo 'Solved: '.$numNows2.'<br />';
echo 'No solved: '.$numNows3.'<br />';

echo '<hr /><br />';
?>
<table>

<?php while( $array = mysql_fetch_assoc($queryRun) ) { ?>
<tr>
    <td><?php echo $id = $array['id'].'<br />';?></td>
        <td><?php echo ( $array['solved'] ? "YES" : "NO" ); ?></td>
</tr>
<?php } // end of while ?>

</table>