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