Search code examples
phpmysqlselect-query

mysql - Set more than one value for 'WHERE' condition

I have the following query:

  $select_query = "SELECT * FROM users WHERE userName='$user_name', password='$password'";

The problem is that the query always fail, so how can I fix the 'WHERE' condition?

Solution

  • You need to use AND

    $select_query = "SELECT * FROM users WHERE userName='$user_name' AND password='$password'";