Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Search / Results variable not passed

New Here ,
Sep 12, 2006 Sep 12, 2006
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
TOPICS
Server side applications
250
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Sep 13, 2006 Sep 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.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 13, 2006 Sep 13, 2006
LATEST
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?
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines