[SOLVED] different results from sql client

[Bendude14]

Ok i am using this same query in mySql console and it works fine but when i use it in php i only get one result back...

 

<?php

  $sql = "SELECT team_name FROM elite_teams WHERE team_id < 10";
  $result = mysql_query($sql) or trigger_error('Query failed: '. mysql_error());
  $teams_row = mysql_fetch_row($result) or trigger_error('Query failed: '. mysql_error());

?>

 

Thanks