Selecting single entry from db

Im having a little problem selecting a single entry from a db><
heres my code

$name= mysql_query(" SELECT 'team_name' FROM `team` WHERE team_id =1");
             if (!$name){
             die("Database query failed: " . mysql_error());
          echo "$name";

i ran it through the sql console in phpmyadmin and it worked fine but when i jumped over into php and tried executing it echos out the following

Resource id#5

any ideas what im dooing wrong?