Skip to main content
Known Participant
September 13, 2006
Question

Search / Results variable not passed

  • September 13, 2006
  • 1 reply
  • 247 views
OK, so I went throught the basic steps of naming a form, creating a list w/ labels & values pulled from a table called MemberList.

The submit button is in GET mode, Action leads to the proper page.

The results page also connects to MemberList and should get the parameter of "category." When I test from within the Dreamweaver Recordset dialogue, it also returns the proper information.

Now that I have posted both files online, the search page will list my values, and the submit redirects w/ URL encoded info. The address looks to be getting the right value from the form, but the results page shows no values at all.

I can't tell where the holdup is, because, judging by the http:// address of the results page, it looks like the search page is passing the right parameters, & by testing the results page from DW, I can get the proper information returned.

Why would this not work with both files posted online?

the link is:
http://www.sidfilmz.com/Talent/pst/membersearch.php
This topic has been closed for replies.

1 reply

Participating Frequently
September 13, 2006
I think this may be a problem with how the recordset is processing the data passed through to it. I'm no php guru I'm afraid, but if you display the full value of the SQL that the second page is displaying it will show you whether that is the problem or not.
beevyarrAuthor
Known Participant
September 13, 2006
The value that the results page is declared like this:
$colname_rsMemberList = "-1";
if (isset($_GET['frm_searchMember'])) {
$colname_rsMemberList = (get_magic_quotes_gpc()) ? $_GET['frm_searchMember'] : addslashes($_GET['frm_searchMember']);
}

I'm not sure what "(get_magic_quotes_gpc())" means, or why the $colname is set to "-1"
Possibly these are areas that should refer to my list from the search page.
Within the Recorset Dialogue of DW, the query has a:

WHERE catergory = 'colname'

and 'colname' is declared w/ Default Value: -1 and w/ RunTime Value: "$_GET['frm_searchMember']"

Is there a more effective way to code this step?