SELECT password from users where username = "$username"?

[johnseito]

Hello everyone,

 

I created a register.php page, and haver user enter the username and password.  Once they enter it, I then create a login.php page.

 

So now user that logins in can enter username and password.  so if they enter a username and supposely this username is in the database, how can i query out the username's associated password?

 

is it this code?

 

  $result = mysql_query("select password from users where username ='$username'");

$info = mysql_fetch_array( $result);


Echo " $info[password]<br>"; 

 

thanks

[pocobueno1388]

Well...they just entered the password with the from. So what you need to do is check if that username AND password exist for a single row, not just the username.

 

<?php

$result = mysql_query("select password from users where username ='$username' AND password='$password'");

if (mysql_num_rows($result) > 0){
   echo "Correct login info!";
} else {
   //wrong info
}

?>

[johnseito]

thanks