The Badger Herald Bar & Dining Guide

ZZZ; } // returns result pointer for SQL query function run_search() { $query = "SELECT * FROM listings WHERE district IN (".districts().")"; if (0 < strlen($_POST['keywords'])) { $keywords = mysql_real_escape_string($_POST['keywords']); $keywords = preg_split("/[ ]+/",$keywords); foreach ($keywords as $keyword) { $query = $query." AND basic_name LIKE '%".$keyword."%'"; } } for ($i = 0; $i < count($_POST); $i++) { ; } return mysql_query($query); } //return list of districts to search for function districts() { $dist_array; $keys = array_keys($_POST); foreach ($keys as $key) { if (preg_match("/dist+/", $key)) { $dist_array[] = preg_replace("/[A-Za-z]+/","",$key); } } $districts = ""; if (0 < count($dist_array)) { for ($i = 0; $i < count($dist_array); $i++) { $districts = $districts."'".$dist_array[$i]."',"; } $districts = substr($districts, 0, -1); } else { $districts = "'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25'"; // $districts = "'1-25'"; } return $districts; } ?> The Badger Herald Bar & Dining Guide - Advanced Search

Bar & Dining Guide

Advanced Search'; search_form(); } else { $result = run_search(); $num_rows = mysql_num_rows($result); echo '

Search Results

'; echo '

Conduct a new search

'; $targets = array("(['])", "([,])"); $replacements = array("", ", "); echo '

'.$num_rows.' venues found. (Districts: '.preg_replace($targets, $replacements, districts()).')

'; include("/var/www/vhosts/badgerherald.com/httpdocs/guide/dining/result.php"); } ?>