note 94638 deleted from function.odbc-field-type by danbrown
| From: | danbrown@php.net | Date: | Mon, 16 Nov 2009 13:54:00 +0000 |
| Subject: | note 94638 deleted from function.odbc-field-type by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-162950@lists.php.net to get a copy of this message | ||
Note Submitter: laff
----
Alternative way for sql 2005 and odbc on winxp
function tableinfo($table){
$tmp=odbc_exec($this->connection, "SELECT COLUMN_NAME, DATA_TYPE, NUMERIC_SCALE,
CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE (TABLE_NAME =
'$table');" );
while($row=odbc_fetch_array($tmp))
$info[array_shift($row)]=$row;
return $info;
}