[SOLVED] 1 form to two databases

[boemboem]

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

[JonnoTheDev]

Insert into database 1

Drop the connection

Connect to database 2 (mysql_connect() & mysql_select_db())

Insert into database 2

 

[boemboem]

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', 'abc@abc.com', '1', 'ar')

 

 

[Mchl]

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', 'abc@abc.com', '1', 'ar')

[boemboem]

lol, that was indeed the error. thx for your help.