Record retriecal using two fields

[rfigley]

I'm currently using this query to retrieve a record to be deleted:

$query = ("select * from tbl_members where phone = '$phone'");

However I need to query for an additional field "chapter" to prevent multiple record retrieval. What is the correct syntax for this?

[bastien]

$query = "select * from tbl_members where phone=$phone and chapter='$chapter'";

assumption - chapter is a alphanumeric field