Jump to content


This topic is now archived and is closed to further replies.


problem retrieving search results

Recommended Posts

I'm having difficulty with a search page. I followed the instructions in the Dreamweaver Help under "Building search/results pages (ColdFusion, ASP, JSP, PHP)", but it seems like the recordset is not recognizing the variables that are coming from the form. The variables [b]are[/b] being passed to the page; I put in a simple "echo($_REQUEST['varFamily']);" line and they show up.

Below is the code being used for the form (most options have been cut for the sake of brevity):
<form action="searchresults.php" method="post" name="searchform" id="searchform">
    <p>Fixture Family:<br />
      <select name="varFamily" id="varFamily">
        <option value="" selected="selected">choose family...</option>
        <option value="Avalon">Avalon</option>
        <option value="Carriage Hills">Carriage Hills</option>
        <option value="Centennial PW">Centennial PW</option>
    <p>Fixture Finish:<br />
      <select name="varFinish" id="varFinish">
        <option value="" selected="selected">choose finish...</option>
        <option value="Antique Silver Crackle">Antique Silver Crackle</option>
        <option value="Burnt Sienna">Burnt Sienna</option>
    <p>Fixture Type:<br />
      <select name="varType" id="varType">
        <option value="" selected="selected">choose type...</option>
        <option value="Accessories">Accessories</option>
        <option value="Bath Fixture">Bath Fixture</option>
    <p>Item Number:<br />
      <input name="itemnumber" type="text" id="itemnumber" />
    <input type="submit" name="Submit" value="Search" />

Here's a screenshot of the recordset window...

...and following is the code it generates:
$varFinish_rs_getSearchResults = "%";
if (isset($HTTP_POST_VARS['varFinish'])) {
  $varFinish_rs_getSearchResults = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['varFinish'] : addslashes($HTTP_POST_VARS['varFinish']);
$varType_rs_getSearchResults = "%";
if (isset($HTTP_POST_VARS['varType'])) {
  $varType_rs_getSearchResults = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['varType'] : addslashes($HTTP_POST_VARS['varType']);
$varItemNumber_rs_getSearchResults = "%";
if (isset($HTTP_POST_VARS['varItemNumber'])) {
  $varItemNumber_rs_getSearchResults = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['varItemNumber'] : addslashes($HTTP_POST_VARS['varItemNumber']);
$varFamily_rs_getSearchResults = "%";
if (isset($HTTP_POST_VARS['varFamily'])) {
  $varFamily_rs_getSearchResults = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['varFamily'] : addslashes($HTTP_POST_VARS['varFamily']);
mysql_select_db($database_conn_catalog, $conn_catalog);
$query_rs_getSearchResults = sprintf("SELECT * FROM catalog WHERE family LIKE '%s' AND fixturefinish LIKE '%s' AND fixturetype LIKE '%s' AND itemnumber LIKE '%s'", $varFamily_rs_getSearchResults,$varFinish_rs_getSearchResults,$varType_rs_getSearchResults,$varItemNumber_rs_getSearchResults);

Any ideas what I'm doing wrong? Thanks in advance!

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.