Go4Expert

Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   PHP: Help needed in PHP MYSQLwith dynamic urls (http://www.go4expert.com/forums/php-help-php-mysqlwith-dynamic-urls-t24090/)

Madhu_byke 4Dec2010 15:02

PHP: Help needed in PHP MYSQLwith dynamic urls
 
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>";

Madhu_byke 4Dec2010 15:42

Re: PHP: Help needed in PHP MYSQLwith dynamic urls
 
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);
        ?>



All times are GMT +5.5. The time now is 22:27.