From: [EMAIL PROTECTED]
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
