Grouping Files in a Loop

whobutsb

Hello All-
I'm working on a document upload section for my website and I have the option to group files together that are of the same nature, IE W4 Forms, I-9 Forms, etc. So as of right now I'm looping through my DB and pulling the names of the files and filename, extension and grouping. Some files will have a grouping others will not. The files that are grouped together I would like to put them all together in a drop down menu list.

I'm wondering what type of loop statement I should use to do this.
Here is how I'm currently looping through the array:

$query = mssql_query("SELECT * FROM tbl ")
while($result = mssql_fetch_array($query)){
    echo "<a href='files/$result[filename']'>$result[name]</a>";
}

Pretty standard but when I get to a file with a grouping I would like to change the output to a drop down menu list.

Any thoughts?

Thanks for the help!

sneakyimp

It's not clear from your post what you are trying to do. I'm guessing that you have a field in your data table called 'grouping' and that field might have several values. Do you mean to say that you want all files where grouping is "w4" to be in a dropdown together while grouping "i-9" is in a different dropdown?

whobutsb

Exactly! I'm sorry that I can't explain it clearly enough. But that is what I'm looking to do. I work in a company where we have 9 business units and they each have there own I-9 Form and W4 Forms so its a pain to have a list and have them all separated out. So a drop down menu is the most efficient way to group them together.

Do you know what type of loop I should use to create this list and dropdown menus? Should I be adding the files that have the grouping name I-9 and W4 to an array and then after create the dropdown menu? If so how would I go about doing this?

Thanks for your help!