From: [EMAIL PROTECTED] Operating system: linux PHP version: 4.1.2 PHP Bug Type: MySQL related Bug description: RC from INSERT INTO if incorrect
hi all $my_sql = "INSERT INTO $table ( my_time ) values( NOW())"; if(!$my_res = mysql_query($my_sql,$my_db)) {echo "ERROR query<BR>".mysql_error($my_db);} $test1 = mysql_insert_id(); $test2 = mysql_affected_rows($my_db); echo "<p>my result $test1 $test2 <br>"; the correct result from $test1 if 1..9 and from $test2 = 1 the entry in the db is correct plz test this link http://62.72.17.147/bug.php4 http://62.72.17.147/bug.phps and the mysql db for local test's http://62.72.17.147/bug.txt sorry for my bad englich ;) Rene -- Edit bug report at http://bugs.php.net/?id=15899&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=15899&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=15899&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=15899&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=15899&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=15899&r=support Expected behavior: http://bugs.php.net/fix.php?id=15899&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=15899&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=15899&r=submittedtwice