ID: 31518
Updated by: [EMAIL PROTECTED]
Reported By: mulder_bravo at yahoo dot com
-Status: Open
+Status: Feedback
Bug Type: MySQL related
Operating System: Windows Xp - Service Pack1
PHP Version: 4.3.10
New Comment:
We need more than this to begin handling this bug. Please tell us what
MySQL version you are using, and give us a code snippet that matches
your output.
$cab=mysql_field_name($result,$i);
echo "Field $i: $cab";
This wouldn't output "Field Int".
A working, minimal example would be beneficial in addition to your
MySQL version.
Previous Comments:
------------------------------------------------------------------------
[2005-01-13 16:27:03] mulder_bravo at yahoo dot com
Ok..
I have this field on the database
CREATE TABLE opiv1 (
idopinion INTEGER(10) UNSIGNED NOT NULL,
comntario LONGTEXT NULL,
PRIMARY KEY(idopinion)
);
when I apply a select function, I need the field name...
I use mysql_field_type on the data collect.
$numcampos=mysql_num_fields($result);
for ($i=0;$i<$numcampos;$i++){
$cab=mysql_field_name($result,$i);
echo "Field $i: $cab";
}
he most to write:
Field Int
Field LongText
and this show me
Field Int
Field Blob
------------------------------------------------------------------------
[2005-01-12 15:24:31] mulder_bravo at yahoo dot com
Description:
------------
When i get a data type, this dont show me the rigth value.
I have a LongText field, when I use mysql_field_type, this show me
blob... why??
Reproduce code:
---------------
$ty=mysql_field_type($result,$i);
echo $ty;
Expected result:
----------------
I expected the right field name, LongText field...
Actual result:
--------------
blob
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=31518&edit=1
