get_results('select distinct wpgvenue_city from wpg_venues'); $select = '
'; //second drop down for venue $vquery = "select id, wpgvenue_name from wpg_venues"; $vquery .= " where wpgvenue_city='" . $_POST["selectcity"] . "'"; $resultsv = $wpdb->get_results($vquery); $select .= '
'; return $select; } function giglogadmin_getconcerts() { global $wpdb; // Shortcodes RETURN content, so store in a variable to return $content = ''; // $content .= ''; $content .= ''; // Use the submitted "city" if any. Otherwise, use the default/static value. $cty = filter_input(INPUT_POST, 'selectcity'); $cty = $cty ? $cty : 'ALL'; $venue = filter_input(INPUT_POST, 'selectvenue'); //echo($_POST['selectvenue']); $venue = $venue ? $venue : '0'; $query = "SELECT wpgc.id, wpgb.wpgband_name as band ,wpgv.wpgvenue_name as venue ,wpgc.wpgconcert_date, wpgc.wpgconcert_tickets, wpgc.wpgconcert_event, wpgv.wpgvenue_city, wpgv.wpgvenue_webpage FROM wpg_concerts wpgc, wpg_bands wpgb, wpg_venues wpgv where wpgc.band=wpgb.id and wpgc.venue = wpgv.id and wpgconcert_date >= CURDATE()"; $query .= ($cty == "ALL") ? "" : " and wpgv.wpgvenue_city='" . $cty . "'"; $query .= ($venue == "0") ? "" : " and wpgv.id='" . $venue . "'"; $query .= " order by wpgv.wpgvenue_city, wpgconcert_date, wpgc.id"; //echo($query); $results = $wpdb->get_results($query); $lastType = ''; foreach ($results AS $row) { $content .= ''; if ($lastType != '' && $lastType != $row->wpgvenue_city) { $content .= ''; } if ($lastType == '') { $content .= ''; } // Modify these to match the database structure // $content .= ''; $content .= ''; $content .= ''; $content .= ''; $fdate = strtotime($row->wpgconcert_date); $newformat = date('d.M.Y', $fdate); //$content .= DATE_FORMAT($fdate,'%d.%b.%Y'); $content .= ''; $content .= ''; $content .= ''; $content .= ''; $lastType = $row->wpgvenue_city; } $content .= '
CITYIDBANDVENUEDATETICKETSEVENT
CITYBANDVENUEDATETICKETSEVENT
' . $row->wpgvenue_city . '
' . $row->wpgvenue_city . '
' . $row->id. '' . $row->band . '' . $row->venue . '' . $newformat . 'TicketsEvent link
'; // return the table return $content; }