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

Reply via email to