Easy SQL question ?

[Anon]

Hello!

I have

$sqlstr = "SELECT * FROM deltagare WHERE email='$mail'";

Now I also want that another thing(both has to be true) has to be true, it is kvittensnummer = $bnummer

(kvittensnummer is a row in the db(datatype int), and $bnummer an int variable)

So I guess that part is written:
kvittensnummer = '$bnummer'

But I having trouble putting it together 🙁

(mySAL, PHP)

Thanks in advance Klas

[Anon]

Solved now, this is the way to do it 🙂

$sqlstr = "SELECT * FROM deltagare WHERE email='$mail' AND kvittensnummer='$bnummer'";

Klas