Which State(s)?
'; } elseif (!isset($_POST['city'])){ echo '
'; $where="where state = '".$_POST['state1']."'"; $cities = array("no"); $cities=getcities ($where,$cities); if (($_POST['state2'])!=="skip"){ $where="where state = '".$_POST['state2']."'"; $cities=getcities ($where,$cities); } if (($_POST['state3'])!=="skip"){ $where="where state = '".$_POST['state3']."'"; $cities=getcities ($where,$cities); } echo'Search any of these cities:
'; echocities($cities,5); echo '
Search for: in: '; echofilter(); echo'
price:  
'; } if(isset($_POST['search'])){ echo '
You searched for "'.$_POST['search'].'"'; $query = preg_replace("# #","+",$_POST['search']); for($cnt=0;$cnt<$_POST['iter'];$cnt++){ if ($_POST["city$cnt"]!="none"){ $n = $_POST["city$cnt"]; echo '
'; echo 'Your Search results for '; echocity($n); echo ''; $url = "http://www.craigslist.org/cgi-bin/search?". "areaID=".$n. "&subAreaID=0". "&query=".$query. "&catAbbreviation=".$_POST['filter']. "&minAsk=".$_POST['min']. "&maxAsk=".$_POST['max']; $file = file_get_contents($url); EchoLinksTable($file,1,8); } } } function echofilter(){ echo ''; } function echocity ($code){ $query = mysql_query ('select city, state_name from CraigSearch where `code`='.$code); if (!$query){echo 'Man, I really suck at MYSQL :('.mysql_error();} $result = mysql_fetch_array($query, MYSQL_NUM); echo $result[0].', '.$result[1]; } function echocities ($cities,$iter){ for ($cnt=0;$cnt<$iter;$cnt++){ echo ''; } echo ''; } function getcities ($where,$cities){ $iter=sizeof($cities); echo '$iter = '.$iter; $query = mysql_query ('select city,code from CraigSearch '.$where.''); if (!$query){echo 'you screweded up'.mysql_error();} while (($result = mysql_fetch_array($query, MYSQL_NUM)) !== false){ $cities[$iter]=$result[0].'|||'.$result[1]; $iter++; } return $cities; } function echostates (){ $query = mysql_query ('select state,state_name from CraigSearch'); if (!$query){echo 'you screweded up'.mysql_error();} while (($result = mysql_fetch_array($query, MYSQL_NUM)) !== false){ if ($result[1]!=$prev_result){ echo ''; } $prev_result=$result[1]; } } function EchoLinksTable ($file,$cols,$date){ preg_match_all("#

 (.*)a>#Uis",$file,$links); $cnt = 0; echo ''; foreach ($links[0] as $link){ if (!preg_match("#TABLE width#",$link)){ if ($cnt == 0){ echo '';} $cnt++; echo ''; if ($cnt == $cols){ echo ''; $cnt = 0; } } } echo '
'.$link.'
'; } ?>