Multiple variables in a mysql query

[codeeighty]

I'm not sure if it possible but what I want to try to do is use 2 variables in a mysql query, such as:

 

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

 

Which doesn't work, there is no error returned and the page never loads, probably messed up syntax

 

The variables would come from a  form with two text boxes, the idea being the ability to display the selected catagory with it's data.

 

I'm sure this is not the best way to do something like this, but this is as far as I've gotten, is something like this possible?

Thanks

[Pikachu2000]

Database/table/field names don't get enclosed in quotes, only string type values do.

[codeeighty]

I should have included the whole string

 

$myQuery1 = "SELECT * FROM table WHERE '$var1' = '$var2'" ;

[Mahngiel]

I should have included the whole string

 

$myQuery1 = "SELECT * FROM table WHERE $var1 = $var2" ;

FIFY

[codeeighty]

Thanks, that works if one field has only numbers for data, but I still need to check it out some more.