SELECT for more than one field

[cmoore67]

very basic question I am sure:

How do I do a search on more than one field?

this does not work:

SELECT FROM table WHERE field1=$var1 and field2=$var2;

Thanks,
Chris

[daarius]

SELECT field1, field2 FROM table WHERE field1='$var1' AND field2='$var2';

good luck,
Daarius...

[cmoore67]

thanks