drop down menu read from mysql

plz i want to make a drop down menu that read from database,i want categories appear and the brands appear inside

 

Ok, that is possible, are the categories in hierarchical presentation or all in same place. A simple example would be.

$combo = "<select name=\"category\">";
$res = mysq_query("SELECT * FROM categories ORDER BY category_title");
while($cat = mysql_fetch_assoc($res)) {
    $combo .= "<option value=\"$cat[category_id]\">$cat[category_title]</option>";
}
$combo .= "</select>";

print $combo;

PHP:

I hope it helps.

regards

 

no i want it drop down menu
as in dynamic drive

 

Show me one example, and we will try poplating it with your database enteries.

regards

 

http://www.dynamicdrive.com/dynamicindex1/slashdot.htm
this is link of menu
my site consists of caterogies which contain subcategories, i want to make categories appear in the dark area and it in the sub categories appear inside the sub menu