Dynamic Slide Down Menu

[RobertSmith]

Hi,
Please see http://www.dynamicdrive.com/dynamicindex17/ddaccordionmenu-glossy.htm

I want to make this menu dynamic. I have two tables - 1. product_classification and 2. products. The tables are innerjoined with a foreign key in the products table. (Connected to product_calssificationID)

The query:

$result = mysql_query("SELECT DISTINCT products.prod_name, product_class.prod_class
FROM (product_class
LEFT JOIN products ON products.prod_class_key=product_class.prodclass_id)") 
or die(mysql_error());  

while($row = mysql_fetch_array( $result)) {
} 

Is this the correct way? Now how do pull the data for the menu?

<?php echo $row['prod_class']; ?>

is not giving result.
Thanks for any help

[rincewind456]

if this

<?php echo $row['prod_class']; ?> 

is outside the while loop then at best it will only show the last prod_class from your query, at worst it's empty, which you don't check for.

Assuming you are pulling more than one record from the DB then you need to manipulate the data within the while loop.

Something like this

while($row = mysql_fetch_array( $result)) {
	$menuItems.= 'li><a href="http://www.dynamicdrive.com/style/csslibrary/category/C1/">'.$row['prod_class'].'</a></li>';
} 

Then echo out the $menuItems where it would fit in with the html code.