Hello i want to make a search engine on a flash site, anyone can help me?
what i want is have 2 kind of results. the search is to find stores.
but it has to work for 2 kinds of results.
the sql database will have this fields:
regions | citys | adresses
But lets imagine someone type his small city i want the exact store, but if someone type one region i want the result to be all stores in that region…
I guess this is probably very simple but i’m searching for a tutorial at about 4 hours and no luck yet
basic search = drop-down with regon names, then in your sql, select * from stores where region is $region
2.advanced search: have user select region (to limit database access), then input (or select, up to you) city => i would dynamically populate a new drop-down with available city names when user makes his selection in the region d-d…
I’d do a select like this
$sql = “Select * from stores where region like ‘%$search%’ or city like ‘%$search%’”;
where $search contains the search string entered by the user.
If it only returns one row, then jump directly to that store. If it returns multiple rows, show the user a list of the stores.
er… i understand how it should be… but can someone give me an example of code or tell me a easy to understand tutorial like… step by step what should i do…