Filtering a drop down menu

Jason,

I have a problem that I can't seem to wrap my head around. Just for background info., all pages were created with DataAssist 2. In the back end admin section, the administrator can insert event details through a form and then check one of two boxes that state whether the event is for Members or Non-members.

On the front end, when a Non-member proceeds to register for a Non-member event they fill out a form that gets emailed to the event host. In that form, I have a pull down menu that's dynamically pulling in a list of all the events so they can select the event they want to attend. The problem is that the list also includes the Member events. How do I go about filtering the list so that only Non-member events appear in the drop down menu?

Do I need a special column in my database so that when the admin checks the Member or Non-member box (on the back end insert page) a value is assigned? Then filter that value on the page with the drop down menu? I'm a bit lost in this department.

yes, you event table would need a column to store the member / non member selection made by the admin.

Lets say for example sake that the column is named eventType, for non member events the event type is set to 0, for member events it is set to 1.


the recordset used to populate the list would be filtered by the eventType, for example:
SELECT * from events WHERE eventType =0

would return only the non member events

Thank you again, Jason. I'm sure I'll be posting back if I run into any issues.

I added a new column to my events table through phpMyAdmin. Any reason why that new column won't show up in Dreamweaver's bindings panel? Tried hitting the refresh button in the bindings panel too, but still nothing.

OSX 10.7.4 / DW CS6

did you add it to the database that Dreamweaver is connected to?

Remember that dreamweaver uses the Testing server settings in your site definition for connecting to the database.

If you use a local testing server, you will need to edit the local database to see the new column in Dreamweaver.

Sometimes, Dreamweaver will need a little kick to see new columns. Close Dreamweaver, then using your OS File manager, browse to your site and delete the _mmServerScripts folder (or use FTP if your testing server is the remote server)

Yes, I've done all you stated with the local database and testing server except giving DW a kickstart. I'll try removing the _mmServerScripts folder later today. Thanks again.