Is there an easier or cleaner way?

[ethought]

$dept_result = array();
$i = 0;
while($row = mysql_fetch_array($result_dept, MYSQL_ASSOC))
{
	$dept_result[$i] = row['department'];
	$i++;		
}

I just need an array built from my query. But I was wondering if there is a cleaner way of doing this or is this pretty much it.

Thanks.

[ethought]

For now I have create d a function to clean up the main part of my code. But still wondering if maybe I am re-inventing the wheel by creating my own function.

Thanks.

[mhalloran]

I think this should work...

$dept_result = mysql_fetch_array($result_dept, MYSQL_ASSOC));

[ethought]

Originally posted by mhalloran
I think this should work...

$dept_result = mysql_fetch_array($result_dept, MYSQL_ASSOC));

I tried that. It doesn't work. I think because the array that it is returning is an array of a single row. You have to loop through while dept_result contains more rows.