Need help to understand how to get only the latest entry from gravity form entry table in wordpress to show in gravity view

user_19828306 0
Viewed 34

I am new to wordpress gravity forms and kit. I am able to save a form data into the database. I am able to resubmit the same form any number of times which adds to multiple entries for it in the database. I have a view form (gravity view) in the front end website to show the saved data from the database. As multiple entries for the same form gets created every time i save the form, I want to fetch the latest entry to display in the front end website. Please explain how to achieve this.

gravity-forms-plugin wordpress
1 Answers

You could do it with a simple MySQL query:

global $wpdb; 

$table = $wpdb->prefix . 'gf_entry_meta';
$sql   = "SELECT * FROM $table ORDER BY `date_created` DESC LIMIT 1";

$result = $wpdb->query($sql);

More on the Gravity Forms database structure here.

user_105569620
Related