predetermined keywords

[WSparrow]

Hello,

 

I'm working on a file upload/download setup.  I want the MySQL table to be arranged like so:

 

id----int(11)----primary key

Filename----varchar(30)

Keyword1----varchar(30)

Keyword2----varchar(30)

Description----text

DateAdded----timestampCURRENT_TIMESTAMP

Type----varchar(30)

Size----int(11) 

Content----mediumblob

 

My question is;

Is there a way to make the users select their keywords from a predetermined list (i.e. a dropdown menu) rather than letting them just punch in whatever keywords they want?

[BlueSkyIS]

yes, just include a <select> in the upload form for each keyword option.

[WSparrow]

You mean something like:

 

<select name="category" class="required" id="select8">

                <option value="" selected></option>

<option value="Pictures">Pictures</option>

[BlueSkyIS]

yes. i assume you'll be processing other form fields, including the file upload. so you can add as many keyword selects as you need and process those values along with the other fields.

[WSparrow]

Right, I think I get it now.

 

Thanks!

 

Nice pic btw