fatcat2010 0 Newbie Poster

Hi experts:
I created a departments table and populated value as follows
SELECT department_id , name,description FROM departments
...the table has
Trading department
Food department
Toy departments
However, I don't know how to create a dropdown in the frontend like this format: ( Mouse over or click "Departments" navigation menu button will trigger a dropdown with list of department names in my mysql "Departments" table. (do i need a javascript to pull out department name from mysql table or sth else?

Home Department About Us
Trading department
Food department
Toy departments

thanks