#33705 [NEW]: Mysql inserts 2 rows, one of them blank

From: halehnb at hotmail dot com Operating system: Windows XP PHP version: 4.4.0 PHP Bug Type: MySQL related Bug description: Mysql inserts 2 rows, one of them blank Description: ------------ I am inserting into 2 tables, and each time in addition to inserting a row with the correct data, a phantom, blank row is inserted. This seems similar to bug #10599 "background attribute in the body tag causes a double insert", but I am not using the "background" tag, and I can't find my error. I am using "background-color" in CSS but I don't see how this could be a problem. What is also weird is that for the "sur_subcategory" table, the data is being inserted near the top of the database table, and not at the bottom like one would expect. Another anomoly: when I use Mozilla (1.4) it double inserts into both tables, but when I use IE (6.0), it only double inserts into one table (sur_category_subcategory). Reproduce code: --------------- $step1 = ''; // sur_subcat table insert $step1 = sprintf("INSERT INTO sur_subcategory (subcat_name) VALUES ('%s')",$subname); $result1 = mysql_query($step1); // get subcat_id to put into sur_cat_sub table $step2 = sprintf("SELECT subcat_id FROM sur_subcategory WHERE subcat_name = '%s'", $subname); $result = mysql_query($step2); $subcat_id = mysql_result($result,0); // insert into sur_cat_sub table $step3 = sprintf("INSERT INTO sur_category_subcategory (category_id,subcat_id,subcat_name) VALUES ('%d','%d','%s')",$category_id,$subcat_id,$subname); $result3 = mysql_query($step3); ?> <br> <? echo ("<b>Your subcategory has been submitted</b>."); mysql_close(); ?> Expected result: ---------------- What I want is for a SINGLE row with the subcat_name to be inserted into table sur_subcategory, and a SINGLE row with the category_id, subcat_id and subcat_name to be inserted into the sur_category_subcategory table. Actual result: -------------- When I insert into sur_subcategory, a row with the correct information is created. However, another row with incorrect information is created too. The same happens when I try to insert into sur_category_subcategory. Example: when $subname = "halehtest1", and the first mysql insert is done, the sur_subcategory table looks like: -- -- Table structure for table sur_subcategory -- CREATE TABLE sur_subcategory ( subcat_id smallint(8) unsigned NOT NULL auto_increment, subcat_name varchar(30) NOT NULL default '', PRIMARY KEY (subcat_id) ) TYPE=MyISAM AUTO_INCREMENT=126 ; -- -- Dumping data for table sur_subcategory -- INSERT INTO sur_subcategory VALUES (124, 'halehtest1'); INSERT INTO sur_subcategory VALUES (125, ''); -- Edit bug report at http://bugs.php.net/?id=33705&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33705&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33705&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33705&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=33705&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=33705&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=33705&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=33705&r=needscript Try newer version: http://bugs.php.net/fix.php?id=33705&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=33705&r=support Expected behavior: http://bugs.php.net/fix.php?id=33705&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=33705&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=33705&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=33705&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33705&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=33705&r=dst IIS Stability: http://bugs.php.net/fix.php?id=33705&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=33705&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=33705&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=33705&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=33705&r=mysqlcfg