//Connect to MYSQL & select Database.
$connection = mysql_connect("mysql6.servage.net","sore4x4", "07850785") or die ("unable to connect to mysql");
$selected = mysql_select_db("sore4x4", $connection) or die ("unable to open database sore4x4");
if(!isset($_POST['state1'])){
echo'
';
}
elseif (!isset($_POST['city'])){
echo '';
}
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 '