[Mysql] Help

[HTML]

What is the correct way to write this query if you're trying to write a login script that verifies BOTH the username and password, this seemed logically, but did not work.

SELECT username,password FROM Users WHERE username = '$username' AND password='$password'

Could anyone tell me how to rewrite please? So that is requires both the username and password to be correct before it logs you in.