PHP and Dreamweaver Dynamic Dropdown Show All Records

I have a dynamic dropdown and dynamic search $GET form and it's using a dynamic dropdown as the source.  All works fine, except how do I put an option on there to remove the filter, in other words, showing all records again in case the user wants to see all the records again?
palmtreeinfotechAsked:
Who is Participating?
 
Ray PaseurConnect With a Mentor Commented:
Dreamweaver often stands in the way of good programming practices; someone else might be able to help with that part.  The way I would approach this is to have a test for an element of $_GET and if it is empty or says something logical like "all" I would eliminate the WHERE clause from the query that creates the record set.
0
 
Jason C. LevineConnect With a Mentor No oneCommented:
If the filter is applied by a form submit, just change the form to allow the user to submit a blank value and then apply Ray's advice to complete the action.
0
 
palmtreeinfotechAuthor Commented:
Cool.  Thanks Ray and Jason.  How would I allow a blank submit from a form field and attach that to a *.* query?
0
 
palmtreeinfotechAuthor Commented:
I may post again when I get to the part I need.  Thanks guys!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.