Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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 $solved = $array['solved'].'<br />'; ?></td>
- </tr>
- <?php } // end of while ?>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement