mysql query from a cmps module

[bvondane]

I already posted this on the vbadvanced forums but I know there are a lot of smart people on this forum so I thought I would post it here as well...

I have a cmps template module that calls a plugin that points to a php page.....and the php file contains a search form that returns the results from a mysql database...

Here's the php file code:

<p>If you would like to add information or have found incorrect information...please <a href="http://www.wheelsup.org/sendmessage.php">suggest an update for this database</a>... </p>
<form action="?" method="GET">
<table border="0" id="table1" cellspacing="0" cellpadding="0" width="0">
<tr>
<td colspan="2">
<strong>Search for Manufacturer Name or Aircraft</strong> (<em>search in development and may not work</em>) <br />
*Tip - searching for "vans" will not return "van's", but searching for
"van" will... </td>
</tr>
<tr>
<td>
<input type="hidden" name="page" value="acmfg">
<input name="searchphrase" type="text" size="40" value="<?=$searchphrase?>">
<input type="submit" value="Search">
<a href="http://www.wheelsup.org/windex.php?page=acmfg">Reset and Show All</a></td>
</tr>
</table>
</form>
<hr size="1">
<hr size="1">
</br>

<?
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$searchphrase=$HTTP_GET_VARS['searchphrase'] ;
$query="SELECT * FROM mfg where name like '%$searchphrase%' or aircraft like '%$searchphrase%' ORDER BY name ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>

<?
$i=0;
while ($i < $num) {
$name=mysql_result($result,$i,"name");
$url=mysql_result($result,$i,"url");
$phone=mysql_result($result,$i,"phone");
$aircraft=mysql_result($result,$i,"aircraft");
$forum=mysql_result($result,$i,"forum");
?>

<b><? echo "$name"; ?></b><br />
<? echo "URL: <a href=http://www.$url target=_blank> http://www.$url</a>"; ?><br />
<? echo "Phone: $phone"; ?><br />
<? echo "Aircraft: $aircraft"; ?><br />
<? echo "Forum: <a href=$forum> $forum</a>"; ?></a><br />
<hr size="1">

<?
++$i;
}
?>


If you just open the page in your browser from its location everything works fine:
http://www.wheelsup.org/modules/acmfg.php

However, if you open the cmps page that includes the module that calls the file the search does not work:
http://www.wheelsup.org/windex.php?page=acmfg

When I perform the search the URL looks correct but it returns everything as if the query string is being stripped somehow...

Any help would be greatly appreciated!
-Bill