"Array" showing up instead of data

[rain62537]

I'm having a problem with extracting fields from an SQL Server database. I've tried to find a reason on many websites to no luck. If anyone can help, I would truly be grateful.

CODE: (I have $connection establesed earlier)

$query = "SELECT department_label FROM departments";
$run = odbc_exec($connection,$query);

while(odbc_num_rows($run)){
$myarray[] = odbc_fetch_array($run);
}
foreach($myarray as $options)
{ print ("$options <br>"); }

OUTPUT: (there are eight records in the table I'm accessing)
Array
Array
Array
Array
Array
Array
Array
Array

[chrisleon]

This is something I wrote earlier today, but I use mysql, but the syntax should be similar

$results = mysql_query("SELECT * FROM table_name);

while ($data = mysql_fetch_array($results))
{
print $data["field_name"];
}

This works for me.

[TheDefender]

chrisleon's advice should help... Basically, what you did was take each row's array and appended it to an array, so when you echoed the results of each array index, that's exactly what you got was a bunch of arrays.