[Resolved] problem with mysql query

[natman3]

I am attempting to check to see if the divisionType is either collegiate or highshcool because the page will display something different for the type.

when i query the dba and echo the result I am not able to view the divisionType which should be either collegiate or highschool does anyone know if i am querying in this script incorrectly?

<?php
 $current_user = $_SESSION['team_id'];
	  $result = mysql_query("SELECT divisionType FROM users WHERE id= '$current_user'") or die('Error : ' . mysql_error());
	  printf("SELECT divisionType FROM users WHERE id= '$current_user'");
	  echo $result;
if($result == 'highschool')
{
do something
}
else
{
show something different
}
?>

[nemonoman]

You need to fetch the result:
$result = mysql_query("SELECT divisionType FROM users WHERE id= '$current_user'") or die('Error : ' . mysql_error());
$row=mysql_fetch_array($result);
$divisiontype=$row['divisionType'];

[natman3]

Thanks that was it.