vb.org Archive - mysql query from a cmps module

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:

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01010 seconds Memory Usage 1,716KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (1)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: