";
$tags .= "\t\t\t\t| " . $i . " | ";
$tags .= "\t\t\t\t" . htmlspecialchars($row['id']) . " | ";
$tags .= "\t\t\t\t" . htmlspecialchars($row['name']) . " | ";
$tags .= "\t\t\t\t" . htmlspecialchars($row['zip']) . " | ";
$tags .= "\t\t\t\t" . htmlspecialchars($row['address']) . " | ";
$tags .= "\t\t\t\t表示 | ";
$tags .= "\t\t\t\n";
$i++;
}
// DBとの接続をクローズ
$db = null;
/**
* ハウス一覧取得SQL
*/
function getHouseListSql() {
$sql = "SELECT\n";
$sql .= " h.id\n";
$sql .= " ,h.name\n";
$sql .= " ,h.zip\n";
$sql .= " ,h.address\n";
$sql .= "FROM\n";
$sql .= " house h\n";
$sql .= ";\n";
return $sql;
}
?>