ID: 29215 Updated by: [EMAIL PROTECTED] Reported By: rudy dot metzger at xs4all dot nl -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Linux RH ES 3 PHP Version: 5.0.0 New Comment:
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. Previous Comments: ------------------------------------------------------------------------ [2004-07-16 16:30:42] rudy dot metzger at xs4all dot nl Description: ------------ mysql_file_type() returns bogus data. PHP 5.0.0 mysql> desc zpm_auth; +----------+-------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------------------+-------+ | userid | varchar(20) | | PRI | | | | username | varchar(50) | YES | | NULL | | | password | varchar(32) | YES | | NULL | | | creusr | varchar(32) | | | | | | credat | datetime | | | 0000-00-00 00:00:00 | | | modusr | varchar(32) | | | | | | moddat | datetime | | | 0000-00-00 00:00:00 | | +----------+-------------+------+-----+---------------------+-------+ 7 rows in set (0.00 sec) mysql> select version(); +--------------------------+ | version() | +--------------------------+ | 4.1.2-alpha-standard-log | +--------------------------+ 1 row in set (0.00 sec) mysql> $sql = "SELECT userid FROM zpm_auth LIMIT 1"; $res = mysql_query( $sql, $this->DBH() ); $this->EvaluateCommand( $res, false, true, $sql ); $colType = mysql_field_type( $res, 0 ); die( $colType ); Works in PHP5 RC3 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=29215&edit=1