Selecting with multiple variables

[webdes03]

I am trying to select from a table where multiple variables are set, here's a snippet of my code:

$query2 = "SELECT * FROM users WHERE FIRSTNAME='$first_name', LASTNAME='$last_name', USERNAME='$username', PASSWORD='$password'";

Its not working for me. Can anyone help please?

[GreyBoy]

Are you getting errors??? You might post your code so we can have a better idea of what the problem is😉

[ctimmer]

$query2 = "SELECT * FROM users WHERE FIRSTNAME='$first_name' AND LASTNAME='$last_name' AND ...