close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Filtering a drop down menu

Thread began 8/07/2012 9:19 am by MikeyT | Last modified 8/09/2012 10:50 am by MikeyT | 543 views | 5 replies |

MikeyT

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.

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

MikeyT

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

Sign in to reply to this post

MikeyT

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

Sign in to reply to this post

Jason ByrnesWebAssist

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)

Sign in to reply to this post

MikeyT

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...