Re: [PHP-DB] Turning result into array from columns

$realones = $row['id']; This line needs to be $realones[] = $row['id']; ...then you will be filling an array instead of just overwriting the same variable repeatedly! -Stephen - Original Message - From: Dave W [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net Sent: Friday,

[PHP-DB] ODBC data types

I am accessing a Microsoft Access 2000 database using the Unified ODBC functions. My problem is that some SQL field types are not recognised and cause the database driver to a (generic) syntax error. For instance odbc_exec($odbc,'CREATE TABLE FormData (formid LONG,dataphp LONG VARCHAR)');