[RESOLVED] Multidimensional array created but i need an associative

[Dereksdontrun]

Hi,

I am querying a MySQL database and need to combine the results into a single array, however the array created seems to be multidimensional with arrays within the array

How do i return a single array with no sub arrays?

$query_rsProblems = sprintf("SELECT DISTINCT problems.problem_1, problems.problem_2,  problems.problem_3,  problems.problem_4
FROM notes JOIN problems ON notes.noteid=problems.noteid 
WHERE admitid = %s", GetSQLValueString($row_rsDischLetter['admitid'], "int"));
$rsProblems = mysql_query($query_rsProblems, $neoData) or die(mysql_error());
$row_rsProblems = mysql_fetch_assoc($rsProblems);

	 do { 
		$result_array[] = $row_rsProblems;

		} while ($row_rsProblems = mysql_fetch_assoc($rsProblems));

  			print_r($result_array);	

Cheers

[vivek151189]

each array in the array represent the different row which internally has multiple column than how it is possible to indexed

[Dereksdontrun]

ok...thanks for the assistance