This content has been marked as final.
Show 2 replies
-
1. Re: Easy MySQL data filtering question
Mike_Watt Feb 21, 2010 10:08 AM (in response to Mike_Watt)Anyone? Anything? I figured this would be an easy one.
I've got the following form fields to search the corresponding columns:
- Company (can be = as form field is dynamically generated with available values)
- Contact Name (same as above)
- Phone (varchar) using LIKE
- Payment Status (int) 1,0
- Sponsor (varchar) can use = as all data was entered using pre-populated drop-down menus.
- Amount Paid (varchar) uses drop-down consisting of ranges (0-99, 100-499, 500-999, 1000-4999, 5000-9999, 10000+)
- Golfer's Name: This is a text field that needs to search 4 different db columns (golfer_1, golfer_2, golfer_3, golfer_4)
So that's what I'm working with and I could REALLY use some help... I've never quite gotten the hang of this.
-
2. Re: Easy MySQL data filtering question
David_Powers Feb 21, 2010 11:53 AM (in response to Mike_Watt)It's not quite as simple as you would like to think. However, the following article in the Dreamweaver Cookbook might help: http://cookbooks.adobe.com/post_Create_search_query_with_optional_fields-16245.html.



