I'm using Jörn's autocomplete plugin from bassistance.de.
What I'd like to do is do a search, which searches two separate
database tables (with different column names) on the same query.
The results will be returned (eg. as JSON) with two objects, each with
results from each table.
So a result like:
[{
table1: {
1:{id:25, name:"John"},
2:{id:34, name:"Bob"}
},
table2: {
1:{id:546, org:"my organization"},
2:{id:23, org:"hospital"},
}
}]
I'm wondering, if possible, how I can get this result data and
populate some other places in the DOM with it, and not fill in the
autocomplete results box? Basically I'm just using the autocomplete to
do the dynamic input for me.
If it's not possible out of the box, please let me know if there is a
more suitable plugin for this! Thanks.
