I have a simple html page that contains several forms on it each of which, when submitted, returns a php page that contains an html table of data that is queried from another (non-drupal) db. I would like to make a drupal page (or pages) that contains a form (or forms) that do the same thing. I am assuming that I would still need to have it return the same return pages that I currently use because they are fetching data from an MSSQL db.
To be more specific, currently my return pages grab a variable from the URL (e.g. htt://myserver/returnpage.php?querystring=foo - foo in this case). It then uses foo in a query and returns a "pretty" html table with the appropriate data. Is there a way to create a drupal form (sorry if there is a better term for this) that contains a textfield that, when submitted, returns a url that has the string entered in the textfield in it somewhere?