I'm trying to use the week() or weekofyear() functions in a php script. Here's a clipping of the code: $sql = "SELECT WEEK('2004/06/01')"; echo $sql; //used for checking purposes $week = mysql_query($sql, $link);//where $link is in an inc file linking that file to this page echo $week; Here is the result I get: SELECT WEEK('2004/06/01') Resource id #3 Am I doing something wrong? Is this supposed to work? Please help!!! :P Thanks, Ben