rendered paste body public static function QueryArray($sql, $key = '', $unique = true, $preserveKey = false, $valueKey = '') { $mysql_result = mysql_query($sql); $rows = array(); if ($key == '') { while ($row = mysql_fetch_assoc($mysql_result)) { $rows[] = $row; } } else { while ($row = mysql_fetch_assoc($mysql_result)) { $k = $row[$key]; if (!$preserveKey) unset($row[$key]); if ($valueKey == '') $val = $row; else $val = $row[$valueKey]; if (!$unique) $rows[$k][] = $val; else $rows[$k] = $val; } } return $rows; }