The query is just working on MySQL is not working on PHP!!!! Please help

[web_designer_iq]

Hello,
The query above is just working on MySQL! But it's not working on PHP!

SELECT user_type, COUNT(user_id) AS sum_users FROM `'._TBLPREFIX.'sessions` GROUP BY user_type ORDER BY sum_users DESC

I have 4 user type defined in Enum type:

• VISITOR

• EMPLOYER

• EMPLOYED

• OFFICE

I want to count them, For example:

• Visitors: 4

• Employeds: 5

• Employers: 6

Please help how can i use the query in PHP file?
I'm using the following code but it's not working true:

	$getWOB = $MySQL->get_rows_array();
$arr = array(
'VISITORS'		=>	$getWOB['sum_users'][0],
'EMPLOYEDS'		=>	($getWOB['sum_users'][1] >= 1)?$getWOB['sum_users'][1]:0,
		'EMPLOYERS'		=>	$getWOB['sum_users']['EMPLOYER'] + $getWOB['sum_users']['OFFICE'] + $getWOB['sum_users']['COMPANY'],
	);

[Fratyr]

What versions of PHP/MySQL you got?

[web_designer_iq]

Apache Web Server Version 2.0.59

PHP Script Language Version 4.4.7

MySQL Database Version 5.0.45

[bradgrafelman]

Show us where you execute the query, and also show us the error message that the MySQL server returns (assuming the query fails and doesn't simply return 0 rows).

[web_designer_iq]

I'm sorry!
The query is right. But how can i view the fields like it:
employers = 10
employeds = 11
etc...
?