unexpected T_ELSEIF

[gw32]

Syntax error found: unexpected T_ELSEIF on line 23

<?php
require("config.php");
$result = mysql_query("SELECT name, mics, status, date_format(eventStart, '%M %e %Y') as start, date_format(eventFinish, '%M %e %Y') as end FROM events where status='S' or status='A' order BY eventStart");
$sta=$row['status'];
{		
	echo "<table rules='rows'>
		<tr>
		<th width='50'><font color='yellow' size='1'>MICS</th>
		<th width='200'><font color='yellow' size='1'>Charity</th>
		<th width='125'><font color='yellow' size='1'>Start Date</th>
		<th width='125'><font color='yellow' size='1'>End Date</th>
		</tr>";
while ($row = mysql_fetch_array($result)) {
		if ($sta == "A");
			{
  				echo "<tr>";
			echo "<td><font color='red' size='1'>" . $row['mics'] . "</td>";
  				echo "<td><font color='red' size='1'>" . $row['name'] . "</td>";
  				echo "<td><font color='red' size='1'>" . $row['start'] . "</td>";
  				echo "<td><font color='red' size='1'>" . $row['end'] . "</td>";
  				echo "</tr>";
			}
		elseif ($sta == "S");
			{
			echo "<tr>";
			echo "<td><font color='#ffffff' size='1'>" . $row['mics'] . "</td>";
  				echo "<td><font color='#ffffff' size='1'>" . $row['name'] . "</td>";
  				echo "<td><font color='#ffffff' size='1'>" . $row['start'] . "</td>";
  				echo "<td><font color='#ffffff' size='1'>" . $row['end'] . "</td>";
  				echo "</tr>";
			}
  		}
	echo "</table>";
}
mysql_close($dbh);
?>
[code]

I don't see it.

Thanks

[Pikachu2000]

Remove semicolon

if ($sta == "A"); // <--- HERE

[DarkerAngel]

there is also a semicolon after the ELSEIF too, there should be no semicolons after your IF statements.

[gw32]

That worked.

 

Now do I have this

 

$sta=$row['status'];

 

in the correct position?

 

Thanks again

[gw32]

Found error about $sta.

 

Thanks

guys.

[DarkerAngel]

That worked.

 

Now do I have this

 

$sta=$row['status'];

 

in the correct position?

 

Thanks again

 

I don't see why you have the curly brackets lines 5 and 34 as it's not enclosing any conditions or loops...

 

$sta=$row['status'];
{		// <- HERE
	echo "<table rules='rows'>

 

and

 

	echo "</table>";
} // <- HERE
mysql_close($dbh);

[Pikachu2000]

As written, $sta will be empty. You're trying to assign it a value before $row['status'] is available. Assuming that 'A' and 'S' are the only possible values for that field, something like this would work for you, with less code.

 

while ($row = mysql_fetch_array($result)) {
   $color = $row['status'] == 'A' ? 'red' : 'white';
   echo "<tr>";
   echo "<td><font color='$color' size='1'>" . $row['mics'] . "</td>";
   echo "<td><font color='$color' size='1'>" . $row['name'] . "</td>";
   echo "<td><font color='$color' size='1'>" . $row['start'] . "</td>";
   echo "<td><font color='$color' size='1'>" . $row['end'] . "</td>";
   echo "</tr>";
}