URL to the working component is:
[url removed, login to view];Itemid=119
I need to add 3 database fields and tweak how the SQL query works. See [url removed, login to view] attached, the red box needs to be added to the backend form.
HOW COMPONENT CURRENTLY WORKS
1. Create a location & a question.
2. Create an event, for example the compass challenge (involves archery and is located in Dublin). Check archery and the two dublin locations.
Fill out the form, select location, events and submit. You will be given a list of events that match your criteria. The form currently searches, location and question.
WHAT IS NEEDED (see [url removed, login to view])
I want to add in the cost of event, and min and max people involved.
When a user submits the form, it will search for an event that matches based on location, event, budget(cost) and is within min/max people.
I need this project done asap.
I can send working component to test.
If the user does not select a budget or number of people, the form will just search location and question (i.e. an event including archery located in Dublin airport).