I seem to be getting unexpected information from a mysql fetch field query.
My table has three fields- here is the schema- CREATE TABLE template ( id smallint(6) NOT NULL auto_increment, name mediumtext NOT NULL, multiple tinyint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (id), UNIQUE id (id) ); Using the samplecode on php.net to output an object containing the properties of eacj field I have been able to output the following Blob - 0 MaxLength - 1 Multiple Key - 0 Name - id Not Null - 1 Numeric - 1 Primary Key - 1 Table - template Type - int Unique Key - 1 Unsigned - 0 ZeroFill - 0 Blob - 1 MaxLength - 7 Multiple Key - 0 Name - name Not Null - 1 Numeric - 0 Primary Key - 0 Table - template Type - blob Unique Key - 0 Unsigned - 0 ZeroFill - 0 Blob - 0 MaxLength - 1 Multiple Key - 0 Name - multiple Not Null - 1 Numeric - 1 Primary Key - 0 Table - template Type - unknown Unique Key - 0 Unsigned - 0 ZeroFill - 0 Which strange as the first field is specified as having a max length of 1 yet it is a small int with a length of 6. Likewise the second field is specified as a blob with a maximum length of 7- yet in my schema it is a medium text. And again my third field is listed as havingan unkniwn typeyet in the schema it is a tinyint Here is my code $TableInfo = new DB; $TableInfoArray = $TableInfo ->MySqlGetTableInfo('SELECT * FROM template'); $a =-1; $b = -1; while (++$a < count($TableInfoArray)){ $Content[++$b] = "Blob - ".$TableInfoArray[$a][0]."<br>"; $Content[++$b] = "MaxLength - ".$TableInfoArray[$a][1]."<br>"; $Content[++$b] = "Multiple Key - ".$TableInfoArray[$a][2]."<br>"; $Content[++$b] = "Name - ".$TableInfoArray[$a][3]."<br>"; $Content[++$b] = "Not Null - ".$TableInfoArray[$a][4]."<br>"; $Content[++$b] = "Numeric - ".$TableInfoArray[$a][5]."<br>"; $Content[++$b] = "Primary Key - ".$TableInfoArray[$a][6]."<br>"; $Content[++$b] = "Table - ".$TableInfoArray[$a][7]."<br>"; $Content[++$b] = "Type - ".$TableInfoArray[$a][8]."<br>"; $Content[++$b] = "Unique Key - ".$TableInfoArray[$a][9]."<br>"; $Content[++$b] = "Unsigned - ".$TableInfoArray[$a][10]."<br>"; $Content[++$b] = "ZeroFill - ".$TableInfoArray[$a][11]."<br>"; $Content[++$b] = "<br>"; } $Content = join('', $Content); return $Content; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php