Please use actual mysql version for server and client 
(4.1.3-beta). If you will be able to reproduce the bug, 
send a reproducable and short testscript (including create 
table statement, and insert statement, output of client 
and server version) and reopen this bug. 

parlnx03> select version();
+-------------------------+
| version()               |
+-------------------------+
| 4.1.3-beta-standard-log |
+-------------------------+
1 row in set (0.00 sec)
 
parlnx03> show create table test;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                           |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test  | CREATE TABLE `test` (
  `a` varchar(50) default NULL,
  `b` int(11) default NULL,
  `c` datetime default NULL,
  `d` float default NULL,
  `e` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
 
parlnx03>


Do not insert any data into the table (in practise, it does not matter if you insert data or not, the result will be the same)

[command] php --version
PHP 5.0.0 (cli) (built: Jul 16 2004 13:57:08)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v2.0.0, Copyright (c) 1998-2004 Zend Technologies

<?php
 
  $dbh = mysql_connect( 'localhost', 'myself', 'mypwd' );
  mysql_select_db( 'test' );
 
  $sql = "SELECT a, b, c, d, e
            FROM test
           LIMIT 1";
  $res = mysql_unbuffered_query( $sql, $dbh );
 
  echo "Following is off by one index!\n";
 
  echo mysql_field_type( $res, 0 )." -> should be A, but is B\n";
  echo mysql_field_type( $res, 1 )." -> should be B, but is C\n";
  echo mysql_field_type( $res, 2 )." -> should be C, but is D\n";
  echo mysql_field_type( $res, 3 )." -> should be D, but is E\n";
  echo mysql_field_type( $res, 4 )." ALWAYS real";
 
  echo " NOTE: A is missing!\n";
 
  mysql_free_result( $res );
 
  mysql_close( $dbh );
 
?>

---------------- SCRIPT OUTPUT --------------------------

[command] php db.php
Following is off by one index!
int -> should be A, but is B
datetime -> should be B, but is C
real -> should be C, but is D
blob -> should be D, but is E
real ALWAYS real NOTE: A is missing!

---------------- END OUTPUT -----------------------------

As you can see, the output is off by one index (actually, the first field should be -1). The last field is always real  (cannot mapped anymore, because index is off). At MySQL 4.1.2 alpha the last one was random (real, unknown, ..)

An easy way to reproduce:
1) create the table
2) modify the script with your userid/pwd
3) run the script

Happy debugging! And hope I could be of some help.

Cheerio
/rudy

Works fine here! 
What does mysql_get_client_info() returns on your machine? 

Darn, I used an old Mysql-shared library of 4.0.18, although I had server/client/devel of 4.1 installed. Removed the old shared rpms and compiled PHP anew and now it works flawlessly!

Sorry to raise this bogus Bug!!! But thanx alot for your quick response and reaction, great work!

Cheerio
/rudy

changing status: closed -> bogus