Bug #16419: Mysql multiple Insert fails...

From: dhaval_adams@yahoo.com Operating system: Linux redhat 7.2 PHP version: 4.0CVS-2002-04-04 PHP Bug Type: MySQL related Bug description: Mysql multiple Insert fails... hi this is my script and it fails when I run it. Sometimes the first one works and some times the second one..however if I run 1 by 1 both of them work but if I run themn in the same script..It fails.. $connect = mysql_pconnect($dbhost, $dbuser, $dbpass); $query = "INSERT INTO transactions (fromid,toid,threadid,messageid,timesent,message,subject,new,unread) VALUES ('$username','$toid','$threadid','$messageid',now(),'$message','$subject', '1', '1')"; $what = "INSERT INTO status (threadid,subject,fromid,toid,fromstatus,tostatus,dateposted) VALUES ('$threadid', '$subject', '$username', '$toid', '1', '1', now())"; $doit = mysql_db_query($dbname,$what); $execute = mysql_db_query($dbname, $query); Thank you Best Regards, Dhaval Desai http://www.netage-me.com -- Edit bug report at http://bugs.php.net/?id=16419&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=16419&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=16419&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=16419&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=16419&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=16419&r=support Expected behavior: http://bugs.php.net/fix.php?id=16419&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=16419&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=16419&r=submittedtwice