https://legacy.forums.gravityhelp.com/topic/populate-drop-down-dynamically-by-database-query-solution Gravity Support Forums Topic: Populate Drop Down dynamically by database Query - Solution. en-US Tue, 21 Apr 2026 14:23:39 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/populate-drop-down-dynamically-by-database-query-solution#post-349763 Fri, 28 Jun 2013 08:20:17 +0000 Rob Harrell 349763@https://legacy.forums.gravityhelp.com/ <p>Solutions are def. allowed here, thanks for posting! </p> https://legacy.forums.gravityhelp.com/topic/populate-drop-down-dynamically-by-database-query-solution#post-346329 Wed, 26 Jun 2013 17:05:30 +0000 gtm1ldy 346329@https://legacy.forums.gravityhelp.com/ <p>If you create a simple form with a single dropdown and want to populate it with a database table that contains all 50 states, Copy and paste the code below, replace the Form ID number and tables. It will work. Hope solutions are allowed here.</p> <p>add_filter("gform_pre_render_5", populate_dropdown); //5 is the GF Form ID<br /> add_filter("gform_admin_pre_render_5", populate_dropdown);</p> <p>function populate_dropdown($form){<br /> global $wpdb; //Accessing WP Database (non-WP Table) use code below.<br /> $results = $wpdb-&gt;get_results("SELECT btc_state_short from btc_state_list");</p> <p> $choices = array();<br /> $choices[] = array("text" =&gt; "Select a State", "value" =&gt; ""); //adding a array option with no value, this will make the user select and option.</p> <p>foreach ($results as $result) {<br /> $choices[] = array("text" =&gt; $result-&gt;btc_state_short, "value" =&gt; $result-&gt;btc_state_short);<br /> }</p> <p> foreach($form["fields"] as &amp;$field){<br /> if($field["id"] == 1){<br /> $field["choices"] = $choices;<br /> }<br /> }</p> <p> return $form;<br /> } </p>