verify the user is in database(help)

[giridharseel]

 

      $q = "SELECT password FROM ".TBL_USERS." WHERE username = '$username'";

      $result = mysql_query($q, $this->connection);

      if(!$result || (mysql_numrows($result) < 1)){

        return 1; //Indicates username failure

      }

 

plz explain the above code

[drisate]

select the password from the table called TBL_USERS where the username is equal to $username

 

Then if no result (!$result) or numbers of row is smaller then 1 (mysql_numrows($result) < 1)) it return 1 (username failure)

[Lodius2000]

why would you be using oop for the connection and not the query, also the use of $this is odd, unless we are inside of a method here