Sorry.// Main query - get all calendar orders
/**
$table_name = 'calendar_orders';
// Prepare and execute query
$query = $wpdb->prepare(
"SELECT * FROM $table_name order by order_index DESC LIMIT 20"
);
$results = $wpdb->get_results($query);
foreach ($results as $row) {
$event_title=$row->event_title;
$event_index=$row->event_index;
$the_email = $row->email;
echo $event_title . "
"; echo $the_email . "
"; $next_table_name = 'cust_id'; // Prepare and execute query $next_query = $wpdb->prepare( "SELECT * FROM $next_table_name where email='htmlspecialchars(lohr.totis@gmail.com)'" ); $results2 = $wpdb->get_results($next_query); foreach ($results2 as $row) { $fname=$row->fname; $lname=$row->lname; echo $fname . $lname; } */ } //}
"; echo $the_email . "
"; $next_table_name = 'cust_id'; // Prepare and execute query $next_query = $wpdb->prepare( "SELECT * FROM $next_table_name where email='htmlspecialchars(lohr.totis@gmail.com)'" ); $results2 = $wpdb->get_results($next_query); foreach ($results2 as $row) { $fname=$row->fname; $lname=$row->lname; echo $fname . $lname; } */ } //}