set a resultset in array

[Anon]

Hi all, me question is, how can i put the data from a field of a recordset in an array. I select some data from a DB2 database and i want to put the contents of a date field in an array.

Any help would be appreciated

Thanks

[Anon]

Quite simple, you have to make a loop running through the result set from your query, and copy it to an array..

for ( $i = 0; $i < odbc_num_rows($result); $i++ )
{
$array[$i] = odbc_result($result,$i);
}

I assume you are using ODBC to access the DB2 database ?