Dynamic text inputs with autocomplete

Project Description:
We have a site built on Linux, Apache, MySQL, PHP (uses the CodeIgniter M-V-C Framework -- http://www.codeigniter.com). We have a variety of forms running on this site -- create an account, log-in, create and edit content, etc.

What we need: form text inputs that are dynamically generated, and each dynamically generated input needs to have autocomplete (or auto-suggest) functionality. The autocomplete lists will be dynamically generated from our MySQL database using PHP.

Please have a look at this super bland example: http://tools.ilaborate.org/jquery_add_another.html All that this example is missing where our needs are concerned is the autocomplete function. If your solution is to upgrade this example to use autocomplete, great. If you have a totally different solution - fine. We prefer Jquery over MooTools or other javascript frameworks.

Please note: the autocomplete functionality has to search everywhere within the result set -- in other words, if the list of items to be used by the autocomplete function are:

Apple
Orange
Banana
Coconut

typing an "o" in the text input field should return "Orange" and "Coconut", not just "Orange". Likewise, typing an "a" should return "Apple", "Orange", "Banana"; typing an "an" returns "Orange" and "Banana"; typing an ana returns "Banana".

In the end we will repurpose this script throughout our site. We will figure out how best to get this working in our set-up which is highly customized. Therefore, simplicity in the end-product is key. The deliverable we are looking for is a working example of a form that works like this one but with autocomplete -- http://tools.ilaborate.org/jquery_add_another.html -- all in one file, or split over several files (eg., HTML file with javascript files linked to it).

Additional Project Description:
06/14/2012 at 16:07 EDT
We also need a working example of this same form prepopulated from an array. We will need this code example to incorporate your work into both add and edit capabilities in our forms. The array can just be a static one; we simply want to understand how your form would accept data from an array and display the prepopulated form. Any of the form fields that you prepopulate should have a "Remove" link associated with it.