In V1 i get used to write SQL Statements inside PHP Code
Example:
$count = $wpdb->get_var(‘SELECT COUNT(*) FROM ‘ . iphorm_get_form_entries_table_name() . ‘ WHERE form_id = 29’); $Tages=$wpdb->get_var(‘SELECT COUNT(*) FROM ‘ . iphorm_get_form_entry_data_table_name() . ‘ WHERE entry_id IN (select id FROM ‘ . iphorm_get_form_entries_table_name() . ‘ WHERE form_id = 29 ) and element_id = 27 and value = “Nein” ‘) ; $DZ=$wpdb->get_var(‘SELECT COUNT(*) FROM ‘ . iphorm_get_form_entry_data_table_name() . ‘ WHERE entry_id IN (select id FROM ‘ . iphorm_get_form_entries_table_name() . ‘ WHERE form_id = 29 ) and (element_id = 27 and value = “Doppelzimmer”) ‘);
These are working on V1 Tables !
Itryed using qzform_get_form_entry_data_table_name instead but it don’t work