mysql help - search on 2 columns

[Blue Cat Buxton]

Is it possible to easily search MYSQL with a php query, on 2 columns at the same time,ie color='red' AND size='medium' for example.

If so how?

[stymiee]

Yes and just like you did it:

WHERE color = 'red' AND size = 'medium';

[Blue Cat Buxton]

doh!

I was convinced I had tried that.

Many thanks