https://legacy.forums.gravityhelp.com/topic/cannot-output-results-of-wpdb-query-to-drop-down-list Gravity Support Forums Topic: Cannot output results of WPDB query to drop down list en-US Sat, 04 Apr 2026 09:20:32 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/cannot-output-results-of-wpdb-query-to-drop-down-list#post-160206 Mon, 04 Mar 2013 16:00:43 +0000 Chris Hajer 160206@https://legacy.forums.gravityhelp.com/ <p>Right after line 14, can you dump the $sob array and see what is contains? It's as if you have the correct number of items, but you're not referencing them correctly. If you can "print_r($sob)" between line 14 and 15, you will see why blank values are being assigned for the option text and value. </p> https://legacy.forums.gravityhelp.com/topic/cannot-output-results-of-wpdb-query-to-drop-down-list#post-156755 Thu, 28 Feb 2013 08:58:50 +0000 lindermyers 156755@https://legacy.forums.gravityhelp.com/ <p>Hi,</p> <p>I have the following function to display values from a custom database table in a DDL.</p> <pre><code>function DDL_Sob($form){ //only populating drop down for form id 27 - Referral global $wpdb; if($form[&quot;id&quot;] != 27) return $form; $sql = &quot;SELECT * FROM &lt;code&gt;bus_source&lt;/code&gt; ORDER BY name&quot;; $sobs = $wpdb-&gt;get_results($sql, ARRAY_N); //Creating drop down item array. $items = array(); $items[] = array(&quot;text&quot; =&gt; &quot;&quot;, &quot;value&quot; =&gt; &quot;&quot;); foreach($sobs as $sob) {$items[] = array(&quot;value&quot; =&gt; esc_attr($sob-&gt;name), &quot;text&quot; =&gt; esc_attr($sob-&gt;name));} //Adding items to field id 15. Replace 15 with your actual field id. You can get the field id by looking at the input name in the markup. foreach($form[&quot;fields&quot;] as &amp;$field) if($field[&quot;id&quot;] == 15){ $field[&quot;choices&quot;] = $items; } return $form; }</code></pre> <p>In mySQL the results are generated and in GF/WP the SELECT/OPTION statements are generated for each row but the values/text are empty as in:</p> <p>&lt;select&gt;<br /> &lt;option value&gt;&lt;/option&gt;<br /> &lt;option value&gt;&lt;/option&gt;<br /> &lt;option value&gt;&lt;/option&gt;<br /> &lt;/select&gt;</p> <p>Any suggestions as to what I've gotten wrong? </p>