Return to Revisions

 Use Below Code for fetching values.it will give you 'field_naam_value' field data.             



    $naam=db_select('profile','pf');
    $naam->join('field_data_field_naam', 'fd', 'pf.pid = fd.entity_id');
    $all_names=$naam->fields('fd',array('field_naam_value'))
               ->condition('pf.uid',4,'=')
               ->execute()
               ->fetchAll(); 
    foreach ($all_names as $record) {
        die;
    }