Get records from Formidable Table using $wpdb->get_col


I am using Formidable Pro as a CRM and one form has a field called cust_id.

Now I want to get all the records stored within that form with a specific cust_id.

I did:

$form_id = 7;
$search_id = 300;

$entries = $wpdb->get_col( $wpdb->prepare(“SELECT id FROM “. $wpdb->prefix .”frm_items WHERE cust_id = %d AND form_id = %d”, $search_id, $form_id) );

But the $entries are empty ??

And there are a few records with the search_id.

Any suggestions on what I am doing wrong ?

FredW 3 years 2019-10-29T07:58:52-05:00 0 Answers 74 views 0

Leave an answer