title: sql help concat
body: <pre><code>SELECT 
      SHA1(CONCAT(users.salt, '$password')) = users.password
  FROM users
  WHERE 
      users.username = '$username'
  </code></pre>
  
  <p>If <code>$username</code> exist this will return true, doesn't matter what password you put in =/</p>
  
  <p>iI only want it to return true if username AND password is correct</p>
  
  <p>What i want is, I want it to take the salt and password, rehash it with sha1 and compare it with user input</p>
  
  <p>What am i doing wrong?</p>