PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Creating Query String

  1. Have read through all the support forums topics on Queries and I am obviously experiencing beginners block and simply can not figure out how to create a query string.

    I use a directory plugin called connections for all my homeowner directories. I would like to create a query that would pull the first and last names from the connections database and allow the user to select them from a drop down. Once the name was chosen the form could then populate the address into in the form.

    wp_connections is the table name, with in the table every account has an id number; first name is mapped first_name and last name is mapped to last_name.

    The test website it:

    http://www.hoaconnections.com/test/

    Any help with this or a pointer in the right direction would be greatly appreciated.

    Posted 11 years ago on Wednesday May 22, 2013 | Permalink
  2. David Peralty

    We can't help with your database queries, but here's our hook for pre-populating a dropdown - http://www.gravityhelp.com/documentation/page/Gform_column_input It might help you figure out how you'll have to set-up the data you get from your database to do what you want with it.

    Posted 11 years ago on Wednesday May 22, 2013 | Permalink
  3. David,

    Thanks for the response... This is well over my head... Any resources you could point me towards for creating this query or maybe just hiring someone to help program this form for me?

    Posted 11 years ago on Wednesday May 22, 2013 | Permalink
  4. David Peralty

    Here is some information on pulling information from a database - http://www.w3schools.com/php/php_mysql_select.asp

    As for hiring a developer, we have a Job Board on this forum, and there are sites like jobs.wordpress.net and Odesk.com where you can hire developers that could do this for you.

    Posted 11 years ago on Wednesday May 22, 2013 | Permalink