autocomplete, php, and mysql
I am working on a form tracking courses to a professor. The code I have written now allows me to pull up any existing courses entered into the database into a dropdown menu. The user can select an existing course or, if the course doesn't exist, hop on over to another field an add a course to the database.
Is there a way I can streamline this so that I can select and add in the same field? I've been looking at bit at mentions of autocomplete, but I'm not sure if it is possible for each autocomplete suggestion to associate itself with the records in my mysql database and for it to create a new course record when the course is new?
I don't need a code or anything, but if you could let me know if it's possible and maybe even point me in the right direction, it'd be great!
Thank you so much!