[Resolved] Insert Prob with drop down menu

[VanPEP]

OK I am trying to create a download manager script, and everything is fine but one thing: On the add a file form I have it so that you can choose wich category to insert the file into from a drop down menu, the menu works fine unless there are no files already avilable, If nothing has been added yet then none of the categories will show up in the menu to select from.

Now this menu also serves dual purpose, it inserts the category id number for the category selected into an xid field in the file database for later use.

Anybody got any ideas on this?

[steve8557]

Hey vanPEP,
Are you storing your categories in a lookup table?

If not you should consider doing this so that you can have full control over the categories available.

The Drop down list would then be populated from the lookup table in your db.
Even if no docs are in the docs table all categories will display.

I guess this will involve an extra query on the db.

Regrads
Steve

[VanPEP]

thank you very much that was a great suggestion, it worked very well