MYSQL search results with choose
Posted: Mon Sep 01, 2008 1:43 pm
Hi there everyone else who is working on Labor Day.
I am trying to find ideas about php query code that will return results that can then be select to continue the program.
There must be a term for this but I just don't have enough history with PHP to know what it is called.
I have an address database, the user enters an address for a look up, if they don't enter the exact address they are out of luck. What I want to do is "if fails" then run a LIKE search and return a list of addresses that might match.
I think I have the code to do the secondary search with the Like and % etc. But I'm stumped with how to display the results in a list that the user can click on and then continue with the program using that address.
We've all seen this on mapquest and superpages when the return other possible address that they have found. That's what I need to accomplish, but don't have any idea of what it is called.
Thanks in advance for any suggestions.
I am trying to find ideas about php query code that will return results that can then be select to continue the program.
There must be a term for this but I just don't have enough history with PHP to know what it is called.
I have an address database, the user enters an address for a look up, if they don't enter the exact address they are out of luck. What I want to do is "if fails" then run a LIKE search and return a list of addresses that might match.
I think I have the code to do the secondary search with the Like and % etc. But I'm stumped with how to display the results in a list that the user can click on and then continue with the program using that address.
We've all seen this on mapquest and superpages when the return other possible address that they have found. That's what I need to accomplish, but don't have any idea of what it is called.
Thanks in advance for any suggestions.