Title: URL params in SQL query
Last modified: March 7, 2023

---

# URL params in SQL query

 *  Resolved [Pascal CESCATO](https://wordpress.org/support/users/pcescato/)
 * (@pcescato)
 * [3 years, 2 months ago](https://wordpress.org/support/topic/url-params-in-sql-query/)
 * Hi! I’ve this shortcode:
 *     ```wp-block-code
       [cf7-recordset id="mydatas" type="database" query="SELECT id, description FROM {wpdb.prefix}mytable"]
       ```
   
 * And it works as expected. But can I in some way add an URL parameter in query,
   like this:
 *     ```wp-block-code
       SELECT mt.id, mt.description FROM {wpdb.prefix}mytable mt WHERE mt.code = $_GET['code']
       ```
   

Viewing 1 replies (of 1 total)

 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [3 years, 2 months ago](https://wordpress.org/support/topic/url-params-in-sql-query/#post-16538172)
 * Hello [@pcescato](https://wordpress.org/support/users/pcescato/)
 * Thank you very much for using our plugin.
 * You can use two recordset fields. The first one reads the URL parameters, and
   fills a hidden field. The second one uses the hidden field value to get the database
   records.
 * Some fields of the form structure would be:
 *     ```wp-block-code
       <input type="hidden" name="code">
       [cf7-recordset id="recordset_url" type="url-parameters"]
       [cf7-link-field recordset="recordset_url" field="code" value="code"]
       [cf7-recordset id="mydatas" type="database" query="SELECT id, description FROM {wpdb.prefix}mytable WHERE code={field.code}"]
       ```
   
 * Best regards.

Viewing 1 replies (of 1 total)

The topic ‘URL params in SQL query’ is closed to new replies.

 * ![](https://ps.w.org/cf7-data-source/assets/icon-256x256.gif?rev=2508392)
 * [Data Source for Contact Form 7](https://wordpress.org/plugins/cf7-data-source/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/cf7-data-source/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/cf7-data-source/)
 * [Active Topics](https://wordpress.org/support/plugin/cf7-data-source/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/cf7-data-source/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/cf7-data-source/reviews/)

## Tags

 * [$_get](https://wordpress.org/support/topic-tag/_get/)
 * [params](https://wordpress.org/support/topic-tag/params/)
 * [query](https://wordpress.org/support/topic-tag/query/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [url](https://wordpress.org/support/topic-tag/url/)

 * 1 reply
 * 2 participants
 * Last reply from: [codepeople](https://wordpress.org/support/users/codepeople/)
 * Last activity: [3 years, 2 months ago](https://wordpress.org/support/topic/url-params-in-sql-query/#post-16538172)
 * Status: resolved