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