adamd

May 21

_mysql() - Select data from rows, grouped by column

This allows for chained queries/linking with other tables, for example, to select `applications` that match the first query.


				Code
				<?php
	$applications_assigned=_mysql(
		'select',
		'computers_applications_assigned',
		array(
			'fields'=>array( //fields you want to return
				'application',
				'license'
				),
			'where'=>array( //query for selection
				'active'=>1,
				)
			),
		array(
			'return-only'=>array('application','license') //fields you want uniques for
			)
		);
?>

Output
			Array (
    [query] => SELECT `application`, `license` FROM `computers_applications_assigned` WHERE `active`='1'
    [result] => Array (
            [application] => Array ( //all values in the 'application' column matching the query
                    [0] => 61
                    [1] => 77
                )
            [license] => Array ( //all values in the 'license' column matching the query
                    [0] => 61
                    [1] => 77
                )
        )
    [results_count] => 2
    [startfrom] => 0
    [remaining] => 0
    [affected_rows] => 2
    [error] => 
)