# Kuler SQL customization request

**URL:** <https://forums.realmacsoftware.com/t/kuler-sql-customization-request/17716>\
**Category:** RapidWeaver Classic\
**Created:** [December 20, 2017, 8:38pm UTC](https://forums.realmacsoftware.com/t/kuler-sql-customization-request/17716 "2017-12-20T20:38:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![therealmf](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/therealmf/32/179_2.png) [@therealmf](https://forums.realmacsoftware.com/u/therealmf)\
**Post date:** [December 20, 2017, 8:38pm UTC](https://forums.realmacsoftware.com/t/kuler-sql-customization-request/17716/1 "2017-12-20T20:38:27Z")

</div>

I am using Kuler SQL to show a therapist database. Now my client wants a small form with two fields where people can enter a range of ZIP codes (“show all therapists from zip code 00000 to zip code 10000” or similar).  
The Kuler SQL Pro Table has a search field, but no range field. It does have a field for a customized query which I have successfully filled in for some “preset” tables showing all addresses with zip 2xxxx and so on.  
But the customized entry by visitors is missing.  
I do have a form that was used on the former website, but I can’t manage to add the two variables for the lower and upper limit into the query on the result page.  
Anybody can help me on that?

---

<div class="post-metadata">

**Author:** ![BrandonCorlett](https://avatars.discourse-cdn.com/v4/letter/b/67e7ee/32.png) [@BrandonCorlett](https://forums.realmacsoftware.com/u/BrandonCorlett)\
**Post date:** [December 21, 2017, 7:16am UTC](https://forums.realmacsoftware.com/t/kuler-sql-customization-request/17716/2 "2017-12-21T07:16:21Z")

</div>

I think you are looking for something like this?

> **[Ajax with PHP MySQL Date Range Search using jQuery DatePicker](https://www.webslesson.info/2016/10/ajax-with-php-mysql-date-range-search-using-jquery-datepicker.html)**
>
> Hello friends in this post we are going to discuss how to make php script for search mysql data between two date without page refresh ...

---

<div class="post-metadata">

**Author:** ![therealmf](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/therealmf/32/179_2.png) [@therealmf](https://forums.realmacsoftware.com/u/therealmf)\
**Post date:** [December 21, 2017, 7:39am UTC](https://forums.realmacsoftware.com/t/kuler-sql-customization-request/17716/3 "2017-12-21T07:39:21Z")

</div>

Great, Brandon!  
While the entire script is too much for my needs, I was able to get the correct syntax for what I wanted to do by going through the code of the script. Thank you so much!!  
If you want to take a look:  
Here’s the page with the full table (all therapists), the map with zip areas and now added the form to manually chose a zip code range of addresses to display. The result is being presented on a different page since I can not alter the code in the KulerSQL Pro Table. But that’s not a problem.

[http://homoeopathie-qualitaet.de/therapeuten](http://homoeopathie-qualitaet.de/therapeuten)

(also helpful if you need a qualified homoeopath while travelling in Germany 😉

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/flex005/user_avatar/forums.realmacsoftware.com/system/32/25301_2.png) [@system](https://forums.realmacsoftware.com/u/system)\
**Post date:** [December 27, 2017, 7:40am UTC](https://forums.realmacsoftware.com/t/kuler-sql-customization-request/17716/4 "2017-12-27T07:40:27Z")

</div>

This topic was automatically closed 6 days after the last reply. New replies are no longer allowed.