Selecting single entry from db

programming
1

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


  <?php 
$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?