|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2010-11-09 14:33 UTC] consatan at gmail dot com
Description: ------------ --- From manual page: http://www.php.net/function.mysql-result --- Test script: --------------- <?php // my php version:5.3.1 $conn = mysql_connect("127.0.0.1", "root", "root") or die(mysql_error()); mysql_select_db("mydb", $conn) or die(mysql_error()); $query = mysql_query("SELECT `desc` FROM `user` WHERE `id`=2", $conn) or die(mysql_error()); $desc = mysql_result($query, 0, 0) or die(mysql_error()); echo "no output<br />"; echo $desc; ?> Expected result: ---------------- I think it must return a string '', may be $desc = ''; The fllowing is test database. CREATE TABLE `user` ( `id` int(4) NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `desc` tinytext DEFAULT NULL, PRIMARY KEY(`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; INSERT INTO `user` VALUES ('u1', ''), ('u2', NULL); PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Nov 07 11:00:01 2025 UTC |
I'm sorry! The test db data is CREATE TABLE `user` ( `id` int(4) NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `desc` tinytext DEFAULT NULL, PRIMARY KEY(`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; INSERT INTO `user` VALUES ('u1', NULL), ('u2', '');