How to get columns and values from database in one array

[oli]

Hi,
I'm searching a way how to get all column names and values from a sql SELECT statement into one array.
Usually I'd use mysqli_fetch_assoc or fetch(PDO::FETCH_ASSOC) but both options doesn't work.

Is there any other possibility?

BR,
Oliver

[kev1n]

Hi,

Something like this?

Code: Select all

function getColumnsArray($table){

	$a  = array();
	$s =  "SHOW COLUMNS FROM `$table`";
	$t = nuRunQuery($s);

	while($r = db_fetch_row($t)){
		$a[] = $r[1];
	}

	return $a;

}

$arr = getColumnsArray('your_table_name_here');

[oli]

Thank you. That is was I'm looking for!

[apmuthu]

Should this get into the core?