read database and add database ??

Anon

Please Helpe..
HOW TO INSERT THE DATA TO THE OTHER DATABASE WHERE THE DATA I GET FROM THE DATABASE TOO ?
I have a problem with add the input to the database,
let's me explain first, i have a question

the first database

ID | userName | password | name | address

I make a Login authorize the user and the password and i want to get the name and address to input the other database ? so the other database is the same data with the first database but only the name and address and the login user and password must correrct
example
user : tina
pass : ASDF
so the user and pass was correct so i get the name and address data
Lady mae, anston road , this data i want to put in the new database example new database only have a id, name, address
but without i must submit again so i want directly the database insert in the new database.

this my script to login
Name this file form.php

<head><title>Login form</title></head>
<body bgcolor="#ffffff">
<form action="login.php" method="post">
<table border="0">
<tr>
<td><strong>Username</strong></td>
<td><input type="text" name="username" size="10" maxsize="50"></td>
</tr>
<tr>
<td><strong>Password</strong></td>
<td><input type="password" name="password" size="10" maxsize="50"</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="Auth me">
</td>
</tr>
</table>
</form>
</body>

Name this file login.php
<?
mysql_connect("localhost", "root", "F0AA2pa8")
or die ("Unable to connect to server.");
mysql_select_db("secretDB")
or die ("Unable to select database.");
$sql = "SELECT id
FROM users
WHERE username='$username' and password='$password'";
$result = mysql_query($sql)
or die ("Unable to get results.");
$num = mysql_numrows($result)
or die ("You're not authorized to be here. If you feel you have recieved this
message in error, please contact the <a
href=\"mailto:me@me.net\">webmaster</a>");
if ($num == 1) {
echo "<p>You can be here<br>";
echo "Your username is $username</p>";
}
?>

junkie_doodle

if ( $REQUEST_METHOD!="POST")
{?>
<head><title>Login form</title></head>
<body bgcolor="#ffffff">
<form action="login.php" method="post">
<table border="0">
<tr>
<td><strong>Username</strong></td>
<td><input type="text" name="username" size="10" maxsize="50"></td>
</tr>
<tr>
<td><strong>Password</strong></td>
<td><input type="password" name="password" size="10" maxsize="50"</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="Auth me">
</td>
</tr>
</table>
</form>
</body>

<?}else{

mysql_connect("localhost", "root", "F0AA2pa8") or die ("Unable to connect to server.");
mysql_select_db("secretDB") or die ("Unable to select database.");

$sql = "SELECT ID,name,address FROM users WHERE username='".$username."' and password='".$password."'";
$result = mysql_query($sql) or die ("Unable to get results.");
$num = mysql_num_rows($result);

if ($num==0)
{?>
<head><title>Login form</title></head>
<body bgcolor="#ffffff"> You're not authorized to be here. If you feel you have recieved this message in error, please contact the <a href="mailto:me@me.net">webmaster</a></body>
<?}else{

	echo "<p>You can be here<br>"; 
	echo "Your username is $username</p>"; 

	$sql_new="insert into new_db (id, name, address) values ('".mysql_result($result,0,"id")."', '".mysql_result($result,0,"name")."', '".mysql_result($result,0,"address")."');

	mysql_query ( $sql_new ) or die ( " can not insert into new_db ");
}

}
?>