Heloo, could you please help me? its really urgent as this is my project. In this code, i want to total up number of people who are pending in this category. Then link it to another page. When going to the link page, it will retrieve the name of the people.

In pending.php:
<?php
    SESSION_START();

    include 'dbFunctions.php';


                 //
    $sql1 = "SELECT * FROM sign_up, category, people WHERE 
   sign_up.category_id = category.category_id AND sign_up.people_id = people.people_id AND
  sign_up.status= 'pending' ";
    $result1 = mysqli_query($link, $sql1) or die(mysqli_error($link));



    ?>


<!DOCTYPE html>
<html>
    <head>
        <title>Students pending</title>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

    </head>

    <body>
        <center><h1><b>pending</b></h1></center>
       <hr/>
       <fieldset>

            <center>

                <table border=1 width="300" height ="100" cellpadding ="1">

                <tr>
                        <th>category id</th>
                         <th>category Name</th>


                </tr>
         <?php
                 while ($row1 = mysqli_fetch_array($result1)){
                 $category = $row1['category_name'];
                 $category_id = $row1['category_id'];
                 ?>



                   <tr>
                       <td width="4"><center><?php echo $category_id ?></center></td>
              <td><center><a href="Data.php?id=<?php echo $category_id; ?>"><?php echo $category ?></a></center></td>

                   </tr>

                  <?php } ?>


                </table>
            </center>

 </fieldset>
 </body>
        </html>














<?php


?>

This is the Java forum, but that's not Java. Try one of the web development or database forums.