Quick mySQL Statement

How do I have multiple 'and' statement in the SQL string

[wonderbread]

Hello everyone,

I'm sure this is a quick fix but I've been going nuts trying to figure it out and am not having much luck searching online. I am doing a simple SELECT sql statement trying to select based on 3 different values.

Code:

$sql = "SELECT * FROM table WHERE var1 = \"$var1\" and var2= \"$var2\" and var3 = \"var3\"";

I'm not sure how to include 3 'and' statements. Any help anyone could provide would be greatly appreciated.

Thanks in advance!

Nick LAdd

[lorax]

$sql = "SELECT * FROM table WHERE var1 = '$var1' AND var2= '$var2' AND var3 = '$var3'";

You had it but just use single quotes for the variables you're testing against.