WSparrow Posted January 14, 2011 Share Posted January 14, 2011 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? Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted January 14, 2011 Share Posted January 14, 2011 yes, just include a <select> in the upload form for each keyword option. Quote Link to comment Share on other sites More sharing options...
WSparrow Posted January 14, 2011 Author Share Posted January 14, 2011 You mean something like: <select name="category" class="required" id="select8"> <option value="" selected></option> <option value="Pictures">Pictures</option> Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted January 14, 2011 Share Posted January 14, 2011 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. Quote Link to comment Share on other sites More sharing options...
WSparrow Posted January 14, 2011 Author Share Posted January 14, 2011 Right, I think I get it now. Thanks! Nice pic btw Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.