[SOLVED] Syntax Error

[maxudaskin]

I hate dislike syntax errors.

 

Error:

Cannot view events. MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1'' at line 1

 

Database:

 

Code:

<?php

function selectDate(){
if(!empty ($_GET['month'])){
   $month = $_GET['month'];
}else{
   $month = gmdate("n");
}
echo "<form id=\"seldate\" name=\"seldate\" method=\"GET\" action=\"events.php\">";
echo "<input type=\"hidden\" name=\"p\" value=\"cal\" />";
echo "<input type=\"hidden\" name=\"do\" value=\"view\" />";
echo "<select name=\"month\">";
if($month == 1){
   echo "<option selected=\"selected\" value=\"1\">January</option>";
}else{
   echo "<option value=\"1\">January</option>";
}
if($month == 2){
   echo "<option selected=\"selected\" value=\"2\">February</option>";
}else{
   echo "<option value=\"2\">February</option>";
}
if($month == 3){
   echo "<option selected=\"selected\" value=\"3\">March</option>";
}else{
   echo "<option value=\"3\">March</option>";
}
if($month == 4){
   echo "<option selected=\"selected\" value=\"4\">April</option>";
}else{
   echo "<option value=\"4\">April</option>";
}
if($month == 5){
   echo "<option selected=\"selected\" value=\"5\">May</option>";
}else{
   echo "<option value=\"5\">May</option>";
}
if($month == 6){
   echo "<option selected=\"selected\" value=\"6\">June</option>";
}else{
   echo "<option value=\"6\">June</option>";
}
if($month == 7){
   echo "<option selected=\"selected\" value=\"7\">July</option>";
}else{
   echo "<option value=\"7\">July</option>";
}
if($month == {
   echo "<option selected=\"selected\" value=\"8\">August</option>";
}else{
   echo "<option value=\"8\">August</option>";
}
if($month == 9){
   echo "<option selected=\"selected\" value=\"9\">September</option>";
}else{
   echo "<option value=\"9\">September</option>";
}
if($month == 10){
   echo "<option selected=\"selected\" value=\"10\">October</option>";
}else{
   echo "<option value=\"10\">October</option>";
}
if($month == 11){
   echo "<option selected=\"selected\" value=\"11\">November</option>";
}else{
   echo "<option value=\"11\">November</option>";
}
if($month == 12){
   echo "<option selected=\"selected\" value=\"12\">December</option>";
}else{
   echo "<option value=\"12\">December</option>";
}
echo "</select>";
echo "<select name=\"year\">";
$i = 2008;
$o = gmdate("Y") + 10;
while($i <= $o){
   if($_GET['year'] == $i){
      echo "<option selected=\"selected\" value=\"" . $i . "\">" . $i . "</option>";
   }else{
      echo "<option value=\"" . $i . "\">" . $i . "</option>";
   }
   $i ++;
}
echo "</select>";
echo "<input type=\"submit\" name=\"Submit\" value=\"Change Month\" />";
echo "</form>";
}

if(!$logged_in){
   die("<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"5\"><tr><td><div align=\"center\" class=\"status_message status_error\">You cannot view this page as you are not logged in.</div></td></tr></table>");
}
if($_SESSION['type'] == 0){
   die("<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"5\"><tr><td><div align=\"center\" class=\"status_message status_error\">You cannot view this page as you are not an administrator.</div></td></tr></table>");
}
/* Define Dates */
$today       = gmdate("Y/m/d"); // Set today's date  | 2008/05/13
$today_unix  = gmdate("Ymd"); //   Set today's date  | 20080513
$today_day   = gmdate("d"); //     Set today's day   | 13
$today_month = gmdate("m"); //     Set today's month | 05
$today_year  = gmdate("Y"); //     Set today's year  | 2008

if(empty($_GET['month'])){
   $month = $today_month;
}else{
   $month = $_GET['month'];
}
if(empty($_GET['year'])){
   $year  = $today_year;
}else{
   $year  = $_GET['year'];
}
$days  = cal_days_in_month(CAL_GREGORIAN, $month, $year);

selectDate();

echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr>";
echo "<td width=\"3%\" style=\"border-top:solid #FFFFFF 1px;\" height=\"20\" align=\"center\" valign=\"middle\" bgcolor=\"#333355\"> </td>";
echo "<td width=\"32%\" colspan=\"2\" style=\"border-top:solid #FFFFFF 1px;\" align=\"center\" valign=\"middle\" bgcolor=\"#333355\"><span class=\"white_text\">Date</span></td>";
echo "<td width=\"65%\" style=\"border-top:solid #FFFFFF 1px;\" align=\"center\" valign=\"middle\" bgcolor=\"#333355\"><span class=\"white_text\">Event(s)</span></td>";
echo "</tr>";
$i = 1;
while($i < $days + 1){
  // Problem Line /////////////////////////////////////////////////////////////////////////////////////////
   $query = mysql_query("SELECT * FROM events WHERE month = '$month' AND year = '$year' AND day '$i'") or die("Cannot view events. MySQL Error: " . mysql_error());
  //////////////////////////////////////////////////////////////////////////////////////////////////////////
   $date  = $year . "/" . $month . "/" . $i;
   $day   = date("l",  strtotime($date));
   echo "<tr style=\"height:18px; vertical-align:middle; background-color:#FFFFFF; padding-left:10px;\" onMouseOver=\"this.style.backgroundColor='#EFF4FB'\" onMouseOut=\"this.style.backgroundColor='#FFFFFF'\">";
   echo "<td height=\"30\"> </td>";
   echo "<td>" . $day . "</td>";
   echo "<td>" . $i . "</td>";
   echo "<td>";
   if(mysql_num_rows($query) > 0){
      while($row = mysql_fetch_array($query)){
         echo "<a href=\"#\"><div>" . $row['name'] . "</div></a>";
      }
   }else{
      echo "No Events.";
   }
   echo "</td>";
   echo "</tr>";
   $i++;
}
echo "</table>";

selectDate();

?>