help needed

[whizzykid]

Hi all,I am creating a website i am almost through with that but when i get to the part of linking the username entered in the databse  to an account i get stuck.

 

can  Any1 help?

[the182guy]

Show us your database structure.

[Maq]

Hi all,I am creating a website i am almost through with that but when i get to the part of linking the username entered in the databse  to an account i get stuck.

 

can  Any1 help?

 

We need more information.  You should have an auto-increment id for the username's primary key.

[whizzykid]

this the code

if (isset($_POST['Login'])) {

  $loginUsername=$_POST['Login'];

  $password=$_POST['Password'];

  $MM_fldUserAuthorization = "";

  $MM_redirectLoginSuccess = "/my profile.php";

  $MM_redirectLoginFailed = "/Login Failed.php";

  $MM_redirecttoReferrer = false;

  mysql_select_db($database_inteecom_ellen, $inteecom_ellen);

 

  $LoginRS__query=sprintf("SELECT Login,Password FROM `Customer Login` WHERE Login=%s AND Password=%s",

    GetSQLValueString($loginUsername, "int"), GetSQLValueString($password, "int"));

 

  $LoginRS = mysql_query($LoginRS__query, $inteecom_ellen) or die(mysql_error());

  $loginFoundUser = mysql_num_rows($LoginRS);

  if ($loginFoundUser) {

    $loginStrGroup = "";

   

    //declare two session variables and assign them

    $_SESSION['MM_Username'] = $loginUsername;

    $_SESSION['MM_UserGroup'] = $loginStrGroup;

 

for every person tht logs in takes them to the same account information,how can i make it display account information per login and password info?  

[Ken2k7]

You have a space in a filename? Why do people do that!? Change the space to %20.

 

Also read guideline #4 - http://www.phpfreaks.com/page/rules-and-terms-of-service#toc_forum_guidelines

[whizzykid]

Hi thank you but the file name is ok,i just want to why everytime any1 logs in it take them to the same account page as every1 else tht logs in.

[Ken2k7]

I'm guessing because you're converting a string into an int in GetSQLValueString($loginUsername, "int"). Same for password. They should be strings.

[whizzykid]

Hi thank you on my database i set to int,

that is not wht i am refering to,i wil explain.

I create a login in form when people login it takes them to a particular redirect page i set,but i want it to display username i get from my form on the the redirect page.