[SOLVED] Parse error: syntax error, unexpect...

[nathanmaxsonadil]

I'm getting this error

Parse error: syntax error, unexpected ';' in /home/nathan/public_html/stixy.php on line 19

 

I looked but I could not find any mistake in my code

can you see if there is something wrong with this code?

code

<?php include 'header.php';  // Works.


?>
<div id="content">
<div id="columnsC"><br/>
	<a href="http://www.stixy.com"><img  style="border:0;" src="siteimg/stixy.jpg" alt="stixy"/></a><Br/>
<p>Stixy helps users organize their world on flexible, shareable Web-based bulletin boards called Stixyboards. Unlike most personal productivity or project management software, Stixy doesn't dictate how users should organize their information. Users can create tasks, appointments, files, photos, notes, and bookmarks on their Stixyboards, organized in whatever way makes sense to them. Then they can share Stixyboards with friends, family, and colleagues.</p>
</div>
<div id="columnsD">
<?
/**
* User has already logged in, so display relavent links, including
* a link to the admin center if the user is an administrator.
*/
if($session->logged_in){
$dbh=mysql_connect ("localhost", "my_username", "my_pass") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("my_db"); 
$query = mysql_query("SELECT stixy FROM emailists WHERE stixy = '{$session->userinfo['email']}'";

$result = mysql_num_rows($query);

if($result !== 0){

echo "<br/><ul><li><a href='stixy.php?remove=1'>Remove yourself from the list</a></li></ul>";

} else {

echo "<br/><ul><li><a href='stixy.php?insert=1'>Add yourself to the list</a></li></ul>";

} 
if(isset($_GET['remove']) && $_GET['remove'] == '1'){
    $sql = "DELETE FROM emailists WHERE stixy=('" . $session->userinfo['email'] . "')";
        if($sqlres = mysql_query($sql)){
            echo 'email address deleted';
        }else{
            echo mysql_error();
        }
}
//break
if(isset($_GET['insert']) && $_GET['insert'] == 1) {
  $sql = "SELECT stixy FROM emailists WHERE stixy = '{$session->userinfo['email']}'";
  if ($result = mysql_query($sql)) {
    if (!mysql_num_rows($result)) {
      $sql = "INSERT INTO emailists (stixy) VALUES ('" . $session->userinfo['email'] . "')";
      if ($sqlres = mysql_query($sql)){
        echo 'email address added';
      } else {
        echo mysql_error();
      }
    } else {
      echo "email address already exists";
    }
  } else {
    echo mysql_error();
  }
}
echo "<ul>";
  $sql = "SELECT stixy FROM emailists";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      while ($row = mysql_fetch_assoc($result)) {
        echo "<li>";  echo $row['stixy'] . "</li>";
        
      }
    }
  }
echo "</ul>";

}
else{
?>
<br/>
<p style="border-style: solid;
border-width: 3px;"><b>To Invite people or add yourself to the list you need to either login or if you dont have an account signup</b></p>

<?
}
?>

</div>



<?php include 'sidebar.php'; ?>
<div style="clear: both;"> </div>
</div>
<?php include 'footer.php';  // Works.

?>

[premiso]

$query = mysql_query("SELECT stixy FROM emailists WHERE stixy = '{$session->userinfo['email']}'");

 

You were missing the ending ) paran.

[phpknight]

You did not close the mysql_query call with a ).