I wanted to send users after signing up straight to 'add a record' to fill their profiles without having to login. I searched the forums and found a solution by JPD for DBMan flat file version.

Here is the code:
___________________________________________________________
You can add the following to sub signup, after the new password is written to the file. The code needs to go after the username is written to the .pass file:

print PASS "$in{'userid'}:$encrypted:$permissions\n";
close PASS;

# This should send the new signup straight into the script instead of making them login again.
$in{'login'} = 1;
$db_uid = "";
($status, $uid, $per_view, $per_add, $per_del, $per_mod, $per_admin) = &auth_check_password;

if ($status eq "ok") {
$db_script_link_url = "$db_script_url?db=$db_setup&uid=$db_uid";
($db_userid) = $db_uid =~ /([A-Za-z0-9]+)\.\d+/; } &html_signup_success;
}

JPD
________________________________________________________

I tried this with SQl version but it does not work. Need help in adapting this to the SQL version. Would greatly appreciate any suggestion on how to approach this.