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
?>