Jump to content

[SOLVED] 1 form to two databases


boemboem

Recommended Posts

// 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

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')

 

 

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')

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.