scrubbicus Posted March 14, 2009 Share Posted March 14, 2009 I'm trying to create a form where someone inputs a State name and gets back information about that state but I want the person to be able to put part of the state name of close to the state name and get back suggested states. So if they entered calif they'd get something back that says did you mean California? So my question is if there's a query options that gets part of my name value from the table or if there isn't how might i go about doing something like this? thanks. Quote Link to comment Share on other sites More sharing options...
Eiolon Posted March 14, 2009 Share Posted March 14, 2009 The SQL itself would be a basic select statement using LIKE. However, what you need to pull it off on the client side is AJAX. I'd search for "Ajax autosuggest" or something similar for some scripts. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.