Hi, I need help with this:

[ted_chou12]

[code]
<?php
require("../mysqlconnection.php");
$sql = "SELECT username FROM userinfo WHERE username = '$username'";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0)
{
$row = mysql_fetch_array($result);
$pass = $row['password'];
if($md5pass == $pass)
return true;
else
return false;}
?>
can anyone have a look at this? because it doesnt get both the uesrname and password at all....
THanks
Ted[/code]

[fert]

change
[code]
$sql = "SELECT username FROM userinfo WHERE username = '$username'";
[/code]
to
[code]
$sql = "SELECT password FROM userinfo WHERE username = '$username'";
[/code]

[ted_chou12]

by the way, my password stored in the database is md5 coded...

[kenrbnsn]

You're only asking for the username from the DB. If you want to retrieve the password you have to ask the DB for it.
[code]<?php
require("../mysqlconnection.php");
$sql = "SELECT username, password FROM userinfo WHERE username = '$username'";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0)
{
        $row = mysql_fetch_assoc($result);
      $pass = $row['password'];
      if($md5pass == $pass)
  return true;
      else
  return false;}
?>[/code]

Ken

[ted_chou12]

thanks, I understand