i am trying to make a dropdown box from and employee database that i have made. this is to do a search by what department people are in. My problem is I do not know how tho make a dropdown box that will list a department only once. this is how my table is set up:
|id|-|name|-|department|
in the department column people can have the same department( example: there are 10 people in accountting)
i tried to use mysql_fetch_row to make a dropdown box but that listed each instance of a department , i just want it to show up once in the dropdown box.
anyone have any idea what i can do ?
|id|-|name|-|department|
in the department column people can have the same department( example: there are 10 people in accountting)
i tried to use mysql_fetch_row to make a dropdown box but that listed each instance of a department , i just want it to show up once in the dropdown box.
anyone have any idea what i can do ?