johnseito Posted April 7, 2008 Share Posted April 7, 2008 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 Quote Link to comment Share on other sites More sharing options...
pocobueno1388 Posted April 7, 2008 Share Posted April 7, 2008 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 } ?> Quote Link to comment Share on other sites More sharing options...
johnseito Posted April 7, 2008 Author Share Posted April 7, 2008 thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.