Query Criteria

Hi All, I need help in below coding as it is not working. What I'm trying to do here, if $type contains "today" value then bring all record which has today's date, If $type contains "tomorrow" bring all tomorrow's record. Do you think below coding is correct? becuase when I run this query I get exception but if I place only one $query and outside of if.. else  the same query runs without errors.     Thank you for your help   Regards   $query; $date = date("d/m/y");   if($type=="today") {   $query = "SELECT * FROM gig where gig_Date= $date"; } else if($type=="tomorrow") {   $tomorrow  = mktime(0, 0, 0, date("m")  , date("d")+1, date("Y"));   $query = "SELECT * FROM gig where gig_Date= $tomorrow"; } else if($type=="week") {   $week  = mktime(0, 0, 0, date("m")  , date("d")+6, date("Y"));   $query = "SELECT * FROM gig WHERE g.gig_Date <= ".$date." OR g.gig_Date >=".$week.";   } $result = mysql_query($query)or die(mysql_error());   return $result;   } ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ