Cannot search more than two fields at once

[Edwinner]

$query = "SELECT * FROM customers WHERE firstname = '$firstname', lastname = '$lastname'";
    $result = mysql_query($query);

i keep getting Error: Query was empty

[cereal]

Use AND OR not comma. The logical operators available for MySQL are these: http://dev.mysql.com/doc/refman/5.0/en/logical-operators.html

So your query becomes:

$query = "SELECT * FROM customers WHERE firstname = '$firstname' AND lastname = '$lastname'";

[Edwinner]

It works! So i guess it is always better to use the "worded" versions of operations?

[cereal]

Yes, AND is defined by the standard ANSI/SQL.