query($sql);
if (DB::isError( $result )) {
die($result->getMessage());
}
while($row = $result->fetchRow()){
$area_id = $row[0];
$area_name = $row[1];
echo $area_name;
?>
店舗名
|
種類
|
麺
|
味濃
|
ス濃
|
背脂
|
その他
|
一言
|
query($sql2);
if (DB::isError( $result2 )) {
die($result2->getMessage());
}
$cnt = 0;
while($row2 = $result2->fetchRow()){
$shop_id = $row2[0];
$shop_name = $row2[1]; // 店名
$point = $row2[2]; // 評価
if($cnt == 0){
echo "" . $shop_name . " | ";
}
if($point == ""){
$point = "−";
for(;$cnt < 7;$cnt++){
printPoint($point);
}
}
else{
printPoint($point);
$cnt = $cnt + 1;
}
//行の終端の場合
if($cnt == 7){
echo "";
$cnt = 0;
}
}
if($cnt > 0){
echo "";
}
?>
|