Hi Webmaster-Talk.

What I am trying to is build a navigation menu which will echo all the categories from my mysql database with the specificic subcategoires below them.

My database contains: id, category, subcategory.

I.E

Category
-Subcategory

I can query the database so it echos all categories, and then echos all subcategories but the problem I have is each subcategory echos the same subcategory underneath it.

Cheers

I have done something very similar to what you are asking... Could you please post your code and I'll compare it to mine.

I'll understand if you think my coding is a complete shambles, i'm really struggling on the mysql: ($title = the title passed in a url e.g http://domain.com/page.php?title=food

PHP Code:

include("dbc.php");
 
<?PHP
$query_sub = "SELECT * FROM webstructure WHERE level_category = '$title' AND level = '3' ORDER BY name DESC LIMIT 10";
            $result_sub = mysql_query($query_sub) 
               or die("Invalid query: " . mysql_error()); 
            while ($row=mysql_fetch_array($result_sub)) {
            $subcategory = $row['name'];
        
?>

<?PHP

echo "";}

?>

<?PHP 
    
// Article rows
include("dbconnect.php");
   
   $query_sub = "SELECT * FROM webstructure WHERE level = '2' ORDER BY name ASC";
            $result_sub = mysql_query($query_sub) 
               or die("Invalid query: " . mysql_error()); 
            while ($row2=mysql_fetch_array($result_sub)) {
            $category = $row2['id'];

echo "<table border = '1'> <tr>";
echo "<td><br><b>$row2[2]</b> <br>";
if  ($subcategory == $subcategory) echo "$subcategory </td>";
echo "</tr></table>";

?>

I am confused as to what you are trying to do. Can you provide an example of the structure of your table `webstructure`?

I do see problems with your script sample above. After your first query, you are overwriting the var $subcategory for each returned row instead assining it to an array element.

Your second query is grabbing from the same table, why can't you combine the results from a single query? The category and subcategory needs some kind of relation so you can match each subcat with each cat.

Well... There are 4 things that I can see at first glance:

1. Your include() statement is outside of the php tags - you should put the include() inside the <?php ?> tags:

include("dbc.php");

2. Next, your while statement - $subcategory = $row['name'] is going to rewrite itself each time through the loop. You should try putting it into an array for example - $arr_subcategory[] = $row['name'] - then loop through the array to display, or just echo the $subcategory right in the while loop:

$query_sub = "SELECT * FROM webstructure WHERE level_category = '$title' AND level = '3' ORDER BY name DESC LIMIT 10";
            $result_sub = mysql_query($query_sub) 
               or die("Invalid query: " . mysql_error()); 
            while ($row=mysql_fetch_array($result_sub)) {
            $subcategory = $row['name'];
        
?>

3. The next while statement - again $category is going to be overwritten each time through the loop, you should assign it to $arr_category[] to create an array:

   $query_sub = "SELECT * FROM webstructure WHERE level = '2' ORDER BY name ASC";
            $result_sub = mysql_query($query_sub) 
               or die("Invalid query: " . mysql_error()); 
            while ($row2=mysql_fetch_array($result_sub)) {
            $category = $row2['id'];

4. Finally, I see a problem with the if statement - $subcategory will ALWAYS be equal to $subcategory as you are comparing it to itself.. For example, you are saying if 1 = 1 then echo 1. You need to compare it to something that is a different variable.

if  ($subcategory == $subcategory) echo "$subcategory </td>";

If I am off course here, just let me know and we'll see what we can do.