How can I set nick name as a username from MySql DB

[nunji]

Hi,

I'm using a login and registration system and I would like to know how can I set a nick name as a username from MySql database?

[OldWolf]

The depends entirely on the user management system you're using... find out how to return the nick from that system, and set it to $params['nick']

[nunji]

Thank you. but I'm confused. the code in brief is:

Code: Select all

HTML form:
user:
<INPUT type="TEXT" name="auth_user_" value="<?php echo $us; ?>" style="width:95px;"></TD>

<?php
                    //if the user-password that was entered is correct
                  {
                     $_SESSION["auth_user_id".$protect_user_group]=$us;  //saves session variable
                     $_SESSION["auth_password_id".$protect_user_group]=$ps;  //saves session variable
            
                     header("Location: x.php"); 
                  }
               
function CheckUserPassword($user,$pass,$with_calc=true)
{
   $sql=@mysql_connect("localhost","root","") ...
   
   $res=@mysql_query("SELECT user FROM user_pass WHERE (user_group='".$protect_user_group."' AND user='".$user."' AND pass='".$c_pass."
?>

So, should I define $params['nick']=$us
or $params['nick']=$user
or something else

[OldWolf]

I would suggest you contact the folks who wrote the software, and ask them how you would go about printing the username. You'll use the same technique here.

[nunji]

Thank you very much
I followed your advice and I found out that $param["nick"]=$_session["auth_user_id.protected_user_group"];

[OldWolf]

Good, glad you got it worked out.