JQUERY UI AUTOCOMPLETE - with MYSQL / AJAX

Must use jQuery UI [login to view URL] for this and not a custom solution -------------------------------------------------------------------------- Your solution will wrap around this but the original jquery autocomplete .js must not be altered -------------------------------------------------------------------------- We are looking for jQuery autocomplete function to include in our framework however we must create a more portable function that we can use based on our database contents. Sometimes we will query customer names, sometimes states or countries. We are looking for a javascript function that we can wrap around the core jQuery UI Autocomplete allowing us to pass a SELECT query string along with css, width, height, background, color and have the dropdown be available. * When the viewer clicks on a field, the mysql database is queried via Ajax / PHP * The result list comes back for viewing in the autocomplete dropdown menu * We must be able to control css styling of the dropdown window and rows via variables in the function call. * The number of fields displayed/visible in the row may be less than the fields requested in the SQL statement. For instance, we may select $sql='field1,field2,field3,field4' for results, but only display field1,field2 in the row. We may indicate this by passing a both an $SELECT variable and a $FIELDS_VISIBLE variable. * We must have a callback function so we may manipulate data based on the row choice. Each field in the row returned should be passed to that function in an array equal to the length of the fields returned in that rows result from the $SELECT statement . * The dropdown must be able to be triggered by either ID(#) or CLASS(.) for any textfield * We must have a final callback function that receives the data of the row that is selected The SQL is a little tricky because we wish for the visible row to be only the fields we may pass in the variable 'fieldsVisible' however the data passed to the final callback function should include all fields from the select statement.