Ошибка анализа: синтаксическая ошибка, неожиданное «else» (T_ELSE)

Я редактирую этот код, чтобы отображать mesaje, когда select имеет значение null, и я получаю эту ошибку:

Parse error: syntax error, unexpected 'else' (T_ELSE) in /nginx/user/reports.php on line 235 

Это код:

  $stmt = $mysqli->prepare("SELECT date, impressions, balance, username FROM reports WHERE username = '$username' and date between '$firstDay' AND '$lastDay'"); $stmt->execute(); $stmt->store_result(); $rows = $stmt->num_rows; mysqli_stmt_bind_result($stmt,$date,$impressions,$balance,$username); if ($rows > 0){ while (mysqli_stmt_fetch($stmt)) { $ecpm_t3 = $balance*1000; $ecpm3 = $ecpm_t3/$impressions; $rate = number_format((float)$ecpm3, 2, '.', ''); echo"<tr> <td class=\"nn\" style=\"text-align:center;\" align=center>$date</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$impressions</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$$rate</td> <td class=\"nn\" style=\"text-align:center;\" align=center nowrap>$$balance</td> </tr>"; } else { echo"<tr> <td colspan=\"4\" class=\"nn\" style=\"text-align:center;\" align=center>Not rows</td> </tr>"; } } 

И строка 235:

  } else { 

Как я могу решить эту ошибку? Что такое плохо ?

Рабочий пример (фиксированный и отформатированный):

 $stmt = $mysqli->prepare("SELECT date, impressions, balance, username FROM reports WHERE username = '$username' and date between '$firstDay' AND '$lastDay'"); $stmt->execute(); $stmt->store_result(); $rows = $stmt->num_rows; mysqli_stmt_bind_result($stmt, $date, $impressions, $balance, $username); if ($rows > 0) { while (mysqli_stmt_fetch($stmt)) { $ecpm_t3 = $balance * 1000; $ecpm3 = $ecpm_t3 / $impressions; $rate = number_format((float)$ecpm3, 2, '.', ''); echo "<tr> <td class=\"nn\" style=\"text-align:center;\" align=center>$date</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$impressions</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$$rate</td> <td class=\"nn\" style=\"text-align:center;\" align=center nowrap>$$balance</td> </tr>"; } } else { echo "<tr> <td colspan=\"4\" class=\"nn\" style=\"text-align:center;\" align=center>Not rows</td> </tr>"; } 

Попробуй это

 <?php $stmt = $mysqli->prepare("SELECT date, impressions, balance, username FROM reports WHERE username = '$username' and date between '$firstDay' AND '$lastDay'"); $stmt->execute(); $stmt->store_result(); $rows = $stmt->num_rows; mysqli_stmt_bind_result($stmt,$date,$impressions,$balance,$username); if ($rows > 0){ while (mysqli_stmt_fetch($stmt)) { $ecpm_t3 = $balance*1000; $ecpm3 = $ecpm_t3/$impressions; $rate = number_format((float)$ecpm3, 2, '.', ''); echo"<tr> <td class=\"nn\" style=\"text-align:center;\" align=center>$date</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$impressions</td> <td class=\"nn\" style=\"text-align:center;\" align=center>$$rate</td> <td class=\"nn\" style=\"text-align:center;\" align=center nowrap>$$balance</td> </tr>"; }} else { echo"<tr> <td colspan=\"4\" class=\"nn\" style=\"text-align:center;\" align=center>Not rows</td> </tr>"; } ?>