[SOLVED] Help with strange mysql query result

[Darkmatter5]

I have a table with 3 enum types all three have valid values of No or Yes.

 

As an example:

$employee_id = 1

Record 1:

  active_employee = Yes

 

If I run the following code

$query="SELECT active_employee
        FROM byrnjobdb.employees
        WHERE employee_id = $employee_id";
$result=mysql_query($query);
$value=mysql_fetch_array($result);

 

and I echo $value, I get "Array". Why does it not say "Yes"?

 

[JonnyThunder]

Because you need to echo the array value....

 

echo $value['fieldnamehere'];

 

[Darkmatter5]

Thanks!