if i have a mysql table with a column with type SET and values x, y,z and a want a listing from all rows where this column has the values x and z, how do i do this in php

thanks in advance

The SQL is...

SELECT * FROM table WHERE field IN('x','z')

This does not explain how to do this in PHP and is a much bigger question

How much PHP do you know?

Does the SQL above mean anything to you?

you code doesn't work

i tried it phpmyadmin

you did change the SQL to reflect your own database / tables / fields didnt you?

of course

otherwise it would return an error

i think i figured out the right mysql code

SELECT * FROM table WHERE field & 5 = 5;

it is a kind of complicated

x values 1, y values 2 and z values 4

a combination of x an z gives you 5 (1+4)

where field = 5 finds all rows with the combination x and z

where field = &5 = 5 finds all rows with the combination x and z and other possible values (in this example y)

Ahhh, bitmasking....
My own very nightmare....