boemboem Posted February 26, 2009 Share Posted February 26, 2009 // This is the insert query for the register part for website (1) mysql_query("INSERT INTO members VALUES ( NULL, '$member[name]', '$ip', '$enurl', '$member[gender]', '$member[country]', '$pass2', '$member[email]', '', 'http://', '', '', '', '', '', 'http://', '', '2', NULL, '$anumber' $extrasql)"); // This is the insert query of the register part for website (2) safe_query("INSERT INTO `".PREFIX."user` (`registerdate`, `lastlogin`, `username`, `password`, `nickname`, `email`, `newsletter`, `activated`, `country`) VALUES ('$registerdate', '$registerdate', '$username', '$md5pwd', '$nickname', '$mail', '1', '".$activationkey."', '$country')"); What I want to accomplish is that the data what normally is insert into (2) also is inserted into (1) I know that the field names are not the same, but it is written to the same database. Can somebody explain to me how I can make a double insert? Quote Link to comment https://forums.phpfreaks.com/topic/146994-insert-form-into-different-tables-in-same-database/ Share on other sites More sharing options...
Mchl Posted February 26, 2009 Share Posted February 26, 2009 You want to insert data into two tables using one query? Not possible. Quote Link to comment https://forums.phpfreaks.com/topic/146994-insert-form-into-different-tables-in-same-database/#findComment-771709 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.