unexpected T_VARIABLE

[Phpfr3ak]

does anyone see why i get an unexpected T_VARIABLE here? Ive varied the code from something i had that was working so i don't see why it fails to work, any help would be great thanks.

 

        <?php
require_once('_includes/db_connection.php');
if ($result = mysql_query('SELECT Banned FROM users WHERE username = '$username'')) {
  if (mysql_num_rows($result)) {
    $row = mysql_fetch_assoc($result);
    if ($row['Banned'] != No) {
      echo "You are banned"; 
      exit;
    }
  }
} ?>

[trq]

if ($result = mysql_query("SELECT Banned FROM users WHERE username = '$username'")) {

[Pikachu2000]

You left the quote open on the line with your query string. Notice how the syntax highlighting colors change at that point? And while you're editing anyhow, you might as well change the quoting on the query string to double quotes, or the variable $username won't be interpolated . . .

 

if ($result = mysql_query("SELECT Banned FROM users WHERE username = '$username'")) {

[Phpfr3ak]

Thanks guys! Once again on the ball thorpe, appreciate all the help you have provided over the last few days.