Parse error: syntax error, unexpected 'else' (T_ELSE) [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 11 years ago.

Improve this question

I edit this code to display a mesaje when select is null and i get this error:

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

This is code:

 $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>";
    }
        }

And line 235 is:

   } else {

How i can resolve this error ? What is bad ?

while can't have an else branch. Count curly braces, indent properly, use IDE. — mario
– mario, Commented Jan 12, 2014 at 13:42

Ilia Ross · Accepted Answer · 2014-01-12 13:49:14Z

Working example (fixed and formatted):

$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>";
     }

user1844933 · Accepted Answer · 2014-01-12 13:50:03Z

Try this

<?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>";
    }


?>

Collectives™ on Stack Overflow

Parse error: syntax error, unexpected 'else' (T_ELSE) [closed]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related