Expression Engine 2 Queries

gistfile1.txt

# Fetch Channel Fields
SELECT
	fg.group_id,
	fg.group_name,
	cf.field_id,
	cf.field_label,
	cf.field_order,
	cf.field_name,
	cf.field_type
FROM
	exp_field_groups fg
LEFT JOIN
	exp_channel_fields cf
ON fg.group_id = cf.group_id
ORDER BY fg.group_name, cf.field_order ASC

# Example Usage 
<?php
	public function fetch_channel_fields()
	{
		$data = array();
		$query = "
			SELECT
				fg.group_id,
				fg.group_name,
				cf.field_id,
				cf.field_label,
				cf.field_order,
				cf.field_name,
				cf.field_type
			FROM
				exp_field_groups fg
			LEFT JOIN
				exp_channel_fields cf
			ON fg.group_id = cf.group_id
			ORDER BY fg.group_name, cf.field_order ASC
		";	
		
		$fields = $this->EE->db->query($query);
		
		if( $fields->num_rows() > 0 )
		{
			foreach( $fields->result_array() as $row )
			{
				$data[ $row['group_id'] ][ $row['field_id'] ] =  $row; 
			}
		}
		return print_r($data);	
	}
?>