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?
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.
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.
palmtreeinfotechAuthor Commented:
Cool.  Thanks Ray and Jason.  How would I allow a blank submit from a form field and attach that to a *.* query?
palmtreeinfotechAuthor Commented:
I may post again when I get to the part I need.  Thanks guys!
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.