国別検索

$area
\n"; print "
\n"; $sql2 = "select a.id,a.country,b.country_id,b.id,a.area from wine_country as a,wine_tsukurite as b where b.country_id = a.id and b.id != '' and a.area = '$area' group by a.country order by a.country"; $result2 = mysql_query($sql2,$con);//クエリを発行する $row2 = mysql_num_rows($result2);//取得したレコード件数を数える $k=0; while($k < $row2){ $id = mysql_result($result2,$k,0); $country = mysql_result($result2,$k,1); if($k != 0){ print " / "; } print "$country"; $k++; } print "
"; $i++; } ?>