My problem is in this below code to find the SubcategoryName that was clicked so that products.php is loaded based on SubcategoryName condition. $result1 = mysql_query("SELECT * FROM subcategory WHERE idCate = $mad "); $result2 = mysql_num_fields($result); while($row = mysql_fetch_array($result1)) { echo "<tr>"; echo "<td>" . '<a href="products.php">' . $row['SubcategoryName'] . '</a>' . "</td>";
Code: <?php require("connect.php"); $result = mysql_query("SELECT * FROM category ORDER BY idcategory"); while($row1 = mysql_fetch_array($result)) { echo "<tr>"; echo "<th>" . $row1['CategoryName'] . "</th>"; echo "</tr>"; $mad = $row1['idcategory']; $result1 = mysql_query("SELECT * FROM subcategory WHERE idCate = $mad "); $result2 = mysql_num_fields($result); while($row = mysql_fetch_array($result1)) { echo "<tr>"; // I actually need the value of the SubcategoryName that is clicked. echo "<td>" . '<a href="products.php">' . $row['SubcategoryName'] . '</a>' . "</td>"; // so that products.php is loaded based on the SubcategoryName that is clicked // echo $row['SubcategoryName']; echo "</tr>"; }; echo "<br />"; } mysql_close($con); ?>