insert form into different tables in same database

[boemboem]

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

[Mchl]

You want to insert data into two tables using one query?

Not possible.