Printable Version of Topic

Click here to view this topic in its original format

HTMLHelp Forums _ Databases _ Search/Answer/Webpage

Posted by: MosesB Oct 6 2011, 10:19 AM

OK...

For a database search tool, i want be able to type a city's name in the search box and pull up the cities webpage that is built into my company's system.

For exmaple...

if Google was a city..

I want to type Google in the search box,(allow to be lower or upper and still pull up the same page,) hit search(or enter) and it go straight to the webpage Google.com.

Can somone please explain how to do this or post code of the example so i can replicate for the website?

Thanks for your help!

Posted by: Brian Chandler Oct 7 2011, 07:14 AM

Well, you need a database with two columns, one being the name of a city and the other the corresponding URL. Then it's elementary db programming to look up the url on the city name, and redirect to it.

Of course, it's hard to see the point of all this. Why can't I just type "San Francisco" into Google?


Posted by: Frederiek Oct 7 2011, 09:53 AM

QUOTE
if Google was a city... I want to type Google in the search box

and
QUOTE
pull up the cities webpage that is built into my company's system


That's not the same as simply typing "San Francisco" into Google.

Posted by: Brian Chandler Oct 7 2011, 11:54 AM

QUOTE(Frederiek @ Oct 7 2011, 11:53 PM) *

QUOTE
if Google was a city... I want to type Google in the search box

and
QUOTE
pull up the cities webpage that is built into my company's system


That's not the same as simply typing "San Francisco" into Google.


No, that's true of course. But if there is just a list of pages for cities, why not simply list them as links? There are bound to be marginal cases, where people are not sure if their own city merits a page...

Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)