I have a searchable product database set up that contains a number of parameters the user can search on. It works great, but the client now wants to have it so that if no result is found with the search, it returns the next closest match.
For example, if a user searches for a length of 1.5, and that exact length is not found, then it would return whatever the closest length is to 1.5.
If anyone could offer some suggestions or ideas as to how that could best be accomplished, I would greatly appreciate it. TIA.
