フリーワードで検索


商店街から検索

';
$html .= '

';
while($str_s = mysql_fetch_array($data_s)){
$nom_s[$cnt_s] = $str_s['nom'];
$shoten[$cnt_s] = $str_s['shoten'];
$html .= '-　'.$shoten[$cnt_s].'
';
$cnt_s++;
}
$html .= '

';
$html .= '

';
}

//カテゴリ検索
$SQL_c ='SELECT * ';
$SQL_c .='FROM suita_category ';
$SQL_c .='ORDER BY category_l ASC , no DESC';
$SQL_c .=';';
$data_c = mysql_query($SQL_c);
if($data_c){
$cnt_c = 0;
$html .= '

';
while($str_c = mysql_fetch_array($data_c)){
$id_c[$cnt_c] = $str_c['no'];
$category_l[$cnt_c] = $str_c['category_l'];
$category_m[$cnt_c] = $str_c['category_m'];
$category_l_url[$cnt_c] = urlencode($str_c['category_l']);
$category_m_url[$cnt_c] = urlencode($str_c['category_m']);
$cnt_c++;
}
$total = $cnt_c;
$cnt_c = 0;
while($total > $cnt_c){
$nextCnt = $cnt_c+1;
$beforeCnt = $cnt_c-1;
$nowGenre = $category_l[$cnt_c];
$nextGenre = $category_l[$nextCnt];
if($cnt_c == 0){
$beforeCnt = 0;
$beforeGenre = "11";
}else{
$beforeGenre = $category_l[$beforeCnt];
}
if(md5($beforeGenre) <> md5($nowGenre)){
$genreBR = str_replace("/","
",$category_l[$cnt_c]);
$html .='

';
}

$cnt_c++;
}
$html .= '

業種から検索
'.$genreBR.' ';
}
$html .= '-　'.$category_m[$cnt_c].'
';
if(md5($nowGenre) <> md5($nextGenre)){
$html .='

';
}

echo $html;

?>