[php]$insert = mysql_query("INSERT INTO cmsdf_users (user_id, user_password) VALUES (’$id’, ‘$cb_leaguepassword’) ON DUPLICATE KEY UPDATE user_password = ‘$cb_leaguepassword’ ") or die(mysql_error());[/php]
thats the ticket worked like a charm i can now run the 2 scripts via cron to create new users in other dB.
Noodles your a star thankyou so much