boemboem Posted February 26, 2009 Share Posted February 26, 2009 // This is the insert query for the register part ladder 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 of the main 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? Thanks a ton in advance! Link to comment https://forums.phpfreaks.com/topic/146987-solved-1-form-to-two-databases/ Share on other sites More sharing options...
JonnoTheDev Posted February 26, 2009 Share Posted February 26, 2009 Insert into database 1 Drop the connection Connect to database 2 (mysql_connect() & mysql_select_db()) Insert into database 2 Link to comment https://forums.phpfreaks.com/topic/146987-solved-1-form-to-two-databases/#findComment-771725 Share on other sites More sharing options...
boemboem Posted February 26, 2009 Author Share Posted February 26, 2009 safe_query("INSERT INTO members VALUES (`name`, `password`, `email`, `act`, `country`) VALUES ('$username', '$md5pwd', '$mail', '".$activationkey."', '$country')"); 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')"); This is what I have this far and it throws an error like: # Query failed: errorno=1064 # error=You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUES ('japster', '1234567890987654321', 'abc@abc # query=INSERT INTO members VALUES (`name`, `password`, `email`, `act`, `country`) VALUES ('japster', '9c27a3e1ff7522869e4849306d9fe441', '[email protected]', '1', 'ar') Link to comment https://forums.phpfreaks.com/topic/146987-solved-1-form-to-two-databases/#findComment-771744 Share on other sites More sharing options...
Mchl Posted February 26, 2009 Share Posted February 26, 2009 Didn't it occur to you that having 'VALUES' twice in INSERT query might not be a good idea? INSERT INTO members (`name`, `password`, `email`, `act`, `country`) VALUES ('japster', '9c27a3e1ff7522869e4849306d9fe441', '[email protected]', '1', 'ar') Link to comment https://forums.phpfreaks.com/topic/146987-solved-1-form-to-two-databases/#findComment-771747 Share on other sites More sharing options...
boemboem Posted February 26, 2009 Author Share Posted February 26, 2009 lol, that was indeed the error. thx for your help. Link to comment https://forums.phpfreaks.com/topic/146987-solved-1-form-to-two-databases/#findComment-771814 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.