get_results(“SELECT a.submit_time,a.field_value as org_logo,a.file,b.field_value as org_name
FROM {$wpdb->prefix}cf7dbplugin_submits a
join {$wpdb->prefix}cf7dbplugin_submits b on b.submit_time = a.submit_time and b.field_name = ‘text-148’
WHERE a.field_name = ‘file-872’
AND (a.form_name = ‘Pledging as an Animal Welfare Organization’ || a.form_name = ‘Pledging as an organization not in Animal Welfare’)
and a.file <> ”
GROUP BY a.submit_time
ORDER BY a.submit_time DESC
LIMIT 9″);
//echo ‘
if(isset($org_file_data ) && !empty($org_file_data ))
{
foreach($org_file_data as $file_key=>$file_val)
{
$org_data[$file_key][‘logo_name’] = $file_val->org_logo;
$org_data[$file_key][‘file_data’] = $file_val->file;
$org_data[$file_key][‘org_name’] = $file_val->org_name;
}
}
//echo ‘
‘;
?>