Bug #16419 Updated: Mysql multiple Insert fails...

ID: 16419 Updated by: hholzgra@php.net Reported By: dhaval_adams@yahoo.com -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Linux redhat 7.2 PHP Version: 4.0CVS-2002-04-04 New Comment: The bug system is not the appropriate forum for asking support questions. For a list of a range of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php Previous Comments: ------------------------------------------------------------------------ [2002-04-04 02:51:19] dhaval_adams@yahoo.com 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 this bug report at http://bugs.php.net/?id=16419&edit=1