comparing array to query string variables

[crawfd]

I have a form that's posting fields via GET POST and I'm trying to query those variables against an array I've stored in a db field called 'cat'. I know I can't use the $row[cat] as is below because I haven't run the query yet. How do I get the value of the field before running the query?

// Where $row[cat] contains array stored in its field - e.g. 1,2,3

$sql = 'SELECT * TABLE WHERE '$_GET[cat]' IN (' . implode(',', $row[cat]) . ')';

[bradgrafelman]

crawfd;11033665 wrote:

an array I've stored in a db field called 'cat'.

There's the first problem I notice. It's likely that a properly normalized DB schema (i.e. no multi-valued columns for one) would make this a much less awkward query.

Are you using MySQL? If so, you're fortunate since MySQL seems to cater to the SQL users who never actually learned SQL standards and provides functions like FIND_IN_SET().