<?php
include 'db.php';
$value = mysql_real_escape_string($_GET['value']);
$name = $_GET['name'];
$count=1;
if($name=='section'){
    $sql = mysql_query("SELECT cat_name,type FROM cats WHERE cat_name LIKE '%{$value}%' ORDER BY pop DESC, cat_name ASC LIMIT 5");
    while($row = mysql_fetch_assoc($sql)){
        foreach($row as $k=>$v){
            $$k=$v;
        }
        $catname=ucwords($cat_name);
        echo '<div class="suggestion" data-id="'.$count.'" onclick="select_sug(this);">'.$catname.'</div>';$count++;
    }
}else if($name=='location'){
    $sql = mysql_query("SELECT area_name,area_parent_name FROM locations WHERE area_name LIKE '{$value}%' ORDER BY pop DESC, area_name ASC LIMIT 5") or die(mysql_error());
    while($row = mysql_fetch_assoc($sql)){
        foreach($row as $k=>$v){
            $$k=$v;
        }
        echo '<div class="suggestion" data-id="'.$count.'" onclick="select_sug(this);">'.$area_name.', '.$area_parent_name.'</div>';$count++;
    }
}

?>