Question about autoComplete
I am using autoComplete to obtain records from my database. I have implemented its use in about 30+ modules. But I just came across a use that is totally something different.
In one table I have over 30k records of individuals. Separate fields for Last and First names. Initially, I just put the autoComplete on the last name. But then I realized that if I enter 'Smith' I only get the first 15 of the Smiths with no way to see the remaining available.
I suppose what I would need to do is use some sort of CONCAT in the mySQL to combine the two names but I don't really have a clue.
Anyone have a suggestion?
TIA for any assistance
jdadwilson
In one table I have over 30k records of individuals. Separate fields for Last and First names. Initially, I just put the autoComplete on the last name. But then I realized that if I enter 'Smith' I only get the first 15 of the Smiths with no way to see the remaining available.
I suppose what I would need to do is use some sort of CONCAT in the mySQL to combine the two names but I don't really have a clue.
Anyone have a suggestion?
TIA for any assistance
jdadwilson
Topic Participants
jamesawilson
jakecigar