I've got a mySQL table on which I am performing a query, and one of the columns is a "set" type. Is there a way to get that column as an array or int (like you can set them) without doing a bunch of queries? (Theoretically, it could be up to 64 queries.) That is, I've got this set of numbers (0-6) representing days of the week, and I want to get all the days of the week on which a given event (that's what the table tracks) is. Can PHP do this? So far, every query I've concocted just returns an empty variable. So:
$foo = mysql_query("SELECT weekday FROM Table WHERE . . . ");
leaves $foo['weekday'] and $foo[0] both empty. Ideas?
