mysql - PHP Echo multiple select queries -

i use following way echo following query

$select_time = mysql_query("select submit_time `table` field_name='user-email' , field_value='test'"); $fetch_time = mysql_fetch_array($select_time); echo $fetch_time['submit_time']; 

can, tell me how echo each values in below scenario

$select_brands = mysql_query("select max(if(`field_name`='brand-name', `field_value`, null )) 'brand-name', max(if(`field_name`='brand-email', `field_value`, null )) 'brand-email', max(if(`field_name`='brand-phone', `field_value`, null )) 'brand-phone', max(if(`field_name`='brand-manager', `field_value`, null )) 'brand-manager' `wp_cf7dbplugin_submits` `form_name` = 'add brands' group `submit_time` order `submit_time` desc limit 0,100"); $fetch_branddetails = mysql_fetch_array($select_brands); 

i need echo brand-name, brand-email, brand-manager , brand-phone stuck syntax how write echo statement this.

it simple

$fetch_branddetails['brand-name']  

or

$fetch_branddetails[0] 

for brand name same goes other columns