Theora Posted September 1, 2006 Share Posted September 1, 2006 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):[code]<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> </select> </p> <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> </select> </p> <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> </select> </p> <p>Item Number:<br /> <input name="itemnumber" type="text" id="itemnumber" /> </p> <p> <input type="submit" name="Submit" value="Search" /> </p></form>[/code]Here's a screenshot of the recordset window...[url=http://img68.imageshack.us/img68/6353/recordsetbx3.gif]http://img68.imageshack.us/img68/6353/recordsetbx3.gif[/url]...and following is the code it generates:[code]$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);[/code]Any ideas what I'm doing wrong? Thanks in advance! Link to comment https://forums.phpfreaks.com/topic/19411-problem-retrieving-search-results/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.