[mysite.com...]
Ideally, I'd like to be able to break apart the above string into it's composite keywords, look those up in the SQL database via whatever process is most-appropriate (ASP?) and then create a page "on the fly" that would contain the text found in the SQL database associated with those keywords.
I know it's possible, but my knowledge is limited, and I'd like to implement this as quickly (ha ha) as possible. So;
1) Which language is best for the interpretation of the query?
2) What kind of equipment/server software will I need to do this?
Hope this doesn't read like a lame request for hand-outs - I genuinely want to put time and effort into this, and would like to know which languages are worth my while learning to get this right.
Many thanks in advance to any who and all who respond.
This is a nice idea that should certainly help convert 404s into useful traffic. There are many ways of going about it, personally I'd use either PHP or Perl for this, along with MySQL.
Why PHP or Perl? Both have very powerful regex functions for parsing text (eg extracting the keywords from the referrer), and both offer good database support for a variety of databases.
Why MySQL? Only because I'm used to it ;)
PHP can handle MS SQL through ODBC (see here [php.net] for details), although I've never done it...
I'm sure ASP could be used effectively, but I'm far from knowledgeable on ASP so I can't offer any pointers.
Your choice of language boils down to both your personal preference and what options you have available - are you running on a unix or NT server? What database system do you use? etc
Hope this was of some help...
We're currently assessing what we need for a big overhaul (which is fantatic), so this will play a part in the redesign.
Thanks again!
