MySQL WHERE multiple matches

[hwdesign]

I want to query the results of a table where three conditions match.

Here's what my current query looks like:

SELECT * FROM wp_variation_values_associations WHERE value_id = $id, product_id = $product AND visible = 1

The problem here is with my WHERE clause. Apparently you can't have more than one?

Any help here would be greatly appreciated.

[anakadote]

use AND, not commas

SELECT * FROM wp_variation_values_associations WHERE value_id = $id AND product_id = $product AND visible = 1