What's wrong with this query?

[Anyaer]

I'm making a query to verify login information via a form. If I do the following query, everything is fine:

$query = "SELECT username, password FROM muse_lab_users";

But once I add the qualifying WHERE, the query fails. I've printed out the $query string, and the $newname and $newpass definately match the username and password fields of one of the entries in the muse_lab_users table.

$query = "SELECT username, password FROM muse_lab_users WHERE username = $newname AND password = $newpass";

PHP version 4.0.6, MySQL version 3.23.32.

[Trs2988]

You have to put quotes around strings in MySQL.

$query = "SELECT username, password FROM muse_lab_users WHERE username = '$newname' AND password = '$newpass'"; 

[Anyaer]

Ah ha. Thank you.