Skip to main content
Participating Frequently
April 22, 2011
Question

Filtering results from a recordset

  • April 22, 2011
  • 5 replies
  • 643 views

HELP - I have created  search page and a results page.  Everything I have set up seems in order.  On my search page I have used the GET option, have named my form object "list" and created a link to the results page and created my labels and values.  However, when i create a recordset on the results page and put a filter in it to select only certain words from one column in the results it either does not show up any results or shows a blank white page in live view.   I have now spent days trying to fix this problem and am not nearer to an answer.   I have used the URL parameter option on the filter list in the recordset set up screen, and made sure that i have the correct spelling etc for the name of my form object on the search page.  When i click test - it comes up with all the right results but when i put all the fields into a table on the results page nothing shows up or now I have a completely blank white screen.  If i put none in the filter box and click live view all my results show up.  HELP PLEASE - ANYONE

This topic is closed to new replies. Start a new post to keep the conversation going.

5 replies

April 22, 2011

Mind readers might be able to help you. For an accurate response others will need your server side scripting language (unmentioned = fail) and your code.

Laura76Author
Participating Frequently
April 22, 2011

sorry - first time in trying to build a website and all this is new to me.  Am using PHP in dreamweaver.  Also using SQL for databases.  Would you need to see code from both search and result pages?  Any advice would be gratefully received. 

April 22, 2011

The query from the results page should suffice. Looking for code similar to SELECT column_name1, column_name2 FROM table_name WHERE....