[glennybee]

I've managed to put this together but it's not working...

 <?php
$dba = mysql_connect('localhost', 'username_vbtest', 'password') or die(mysql_error());
$sql = "
INSERT INTO username_vbtest.user (
   post_thanks_user_amount,
   post_thanks_thanked_posts,
   post_thanks_thanked_times
)
SELECT (
   username_test.user.post_thanks_user_amount,
   username_test.user.post_thanks_thanked_posts,
   username_test.user.post_thanks_thanked_times
)
FROM username_test.user
";
$result = mysql_query($sql) or die(mysql_error()); 

mysql_close($dba);

I'd really appreciate any help with this. Thanks!

'vbtest' is the destination database and 'test' is the source database.