ID: 41218
Comment by: eugene dot pikalov at gmail dot com
Reported By: dailu at mail dot ru
Status: Open
Bug Type: MySQL related
Operating System: Windows XP Pro
PHP Version: 5.2.1
New Comment:
Write result of your script.
>>table contain two equal records
How you have learned about it?
Previous Comments:
------------------------------------------------------------------------
[2007-04-28 06:13:06] dailu at mail dot ru
Description:
------------
Table is empty. I insert one record in table. In spite that table
contain two equal records, although at output record is single. I used
mysql 5.0.20.
P.S.: I'm from Russia, sorry for my english..
Reproduce code:
---------------
mysql_connect('localhost', 'root', NULL);
mysql_select_db('localhost');
echo ' Before:<br/>';
$result = mysql_query('SELECT * FROM `documents`');
while($array = mysql_fetch_assoc($result))
printf('%d.%d %s<br/>', $array['id'], $array['id_branch'],
$array['name']);
// Table is empty
mysql_query("INSERT INTO `documents` (`id`,`id_branch`,`name`) VALUES
(NULL, 1, 'Record2')");
echo ' After:<br/>';
$result = mysql_query('SELECT * FROM `documents`');
while($array = mysql_fetch_assoc($result))
printf('%d.%d %s<br/>', $array['id'], $array['id_branch'],
$array['name']);
Expected result:
----------------
Before:
After:
1.1 Record2
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=41218&edit=1
