Gravity Support Forums Topic: Can't access Gravity Forms table?

Gravity Support Forums Topic: Can't access Gravity Forms table? https://legacy.forums.gravityhelp.com/topic/cant-access-gravity-forms-table Gravity Support Forums Topic: Can't access Gravity Forms table? en-US Mon, 20 Apr 2026 10:03:53 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Search]]> q https://legacy.forums.gravityhelp.com/search.php Chris Hajer on "Can't access Gravity Forms table?" https://legacy.forums.gravityhelp.com/topic/cant-access-gravity-forms-table#post-36132 Sat, 24 Sep 2011 13:17:55 +0000 Chris Hajer 36132@https://legacy.forums.gravityhelp.com/ Great. Glad that worked out for you. ThomasUmstattd on "Can't access Gravity Forms table?" https://legacy.forums.gravityhelp.com/topic/cant-access-gravity-forms-table#post-35965 Thu, 22 Sep 2011 13:01:36 +0000 ThomasUmstattd 35965@https://legacy.forums.gravityhelp.com/ Wow! That worked. Fabulous! Chris Hajer on "Can't access Gravity Forms table?" https://legacy.forums.gravityhelp.com/topic/cant-access-gravity-forms-table#post-35931 Wed, 21 Sep 2011 21:56:31 +0000 Chris Hajer 35931@https://legacy.forums.gravityhelp.com/ Try this as line 4 of your code (the line after global $wpdb;) <pre><code>[php] $wpdb->rg_lead_detail = $wpdb->prefix . 'rg_lead_detail';</code></pre> The query works fine for the posts table since that is defined as part of the wpdb object already. I think you have to define rg_lead_detail yourself. It worked for me. ThomasUmstattd on "Can't access Gravity Forms table?" https://legacy.forums.gravityhelp.com/topic/cant-access-gravity-forms-table#post-35925 Wed, 21 Sep 2011 20:18:42 +0000 ThomasUmstattd 35925@https://legacy.forums.gravityhelp.com/ Oh, and I dumped $mylink using var_dump($mylink); and it returned "NULL". ThomasUmstattd on "Can't access Gravity Forms table?" https://legacy.forums.gravityhelp.com/topic/cant-access-gravity-forms-table#post-35924 Wed, 21 Sep 2011 20:17:13 +0000 ThomasUmstattd 35924@https://legacy.forums.gravityhelp.com/ Btw, I had the <a href="http://wordpress.org/extend/plugins/gravity-forms-addons/" rel="nofollow">Gravity Forms Directory & Addons</a> plugin activated. I thought that perhaps it was conflicting so I deactivated it but it hasn't made a difference. ThomasUmstattd on "Can't access Gravity Forms table?" https://legacy.forums.gravityhelp.com/topic/cant-access-gravity-forms-table#post-35923 Wed, 21 Sep 2011 20:11:47 +0000 ThomasUmstattd 35923@https://legacy.forums.gravityhelp.com/ Yeah, it's just an everyday template file for a regular old page. If I use the virtually identical code below that queries a WordPress default table it works. <pre><code><?php function show_signers() { global $wpdb; $mylink = $wpdb->get_row("SELECT * FROM $wpdb->posts WHERE ID = 116"); echo "The Title is: " . $mylink->post_title; } show_signers(); ?></code></pre> Any thoughts? Do you have any examples of code that work for you? Chris Hajer on "Can't access Gravity Forms table?" https://legacy.forums.gravityhelp.com/topic/cant-access-gravity-forms-table#post-35921 Wed, 21 Sep 2011 19:48:04 +0000 Chris Hajer 35921@https://legacy.forums.gravityhelp.com/ If you dump the array $mylink, what's in it? Where does this code live? Is it in a template file? ThomasUmstattd on "Can't access Gravity Forms table?" https://legacy.forums.gravityhelp.com/topic/cant-access-gravity-forms-table#post-35920 Wed, 21 Sep 2011 19:45:58 +0000 ThomasUmstattd 35920@https://legacy.forums.gravityhelp.com/ Hi guys, I've been working on this for the past 4 hours and I'm ready to pull my hair out. ;) All I'm trying to do is display some of the values in the Gravity Forms custom table. But no matter what parameters I adjust, I can't get it to show anything. At the same time, I can pull and display data from the WordPress default tables with a problem (e.g. wp_users, wp_links, wp_comments, etc.) Below is the code I'm fighting with: <pre><code><?php function show_signers() { global $wpdb; $mylink = $wpdb->get_row("SELECT * FROM $wpdb->rg_lead_detail WHERE id = 117"); echo "The ID is: " . $mylink->form_id; } show_signers(); ?></code></pre> But all that shows up are the words "The ID is: ". I've verified that values do exist in the Gravity Forms table that I'm trying to access. So... what am I doing wrong? Thanks!