php sql html,使用php将sql表输出为HTML

我需要我的PHP打印出所有天气报告的HTML表格以及该人员的姓名和电子邮件。

它给了我一个错误

警告：mysqli_stmt :: bind_result()：绑定变量的数量与预准备语句中的字段数不匹配

这是我的代码

$query = "SELECT weather.report,

cities.name, cities.email FROM weather INNER JOIN cities ON weather.city=cities.city ";

$stmt = $mysqli->stmt_init();

if ($stmt->prepare($query)) {

//$stmt->bind_param("s", $player);

$stmt->execute();

$stmt->bind_result($tempCity, $tempReport, $tempName, $tempEmail);

echo "

Temperature	Report	City	DATE

while ($stmt->fetch()) {

echo "

".$tempCity."".$tempReport."".$tempName."".$tempEmail."\n";

}

echo "

";

$stmt->close();

} else {

$error = "Sorry could not retrieve information"; echo $error; return;

}

$mysqli->close();感谢您的任何帮助