[sabret00the]

nope i'm trying to do a select based on the existence of a <string> in a <list> kinda like a while

so "SELECT * FROM prs_styles WHERE FIND_IN_SET(1, 1 5 10 15 20 25 30) ORDER BY catid ASC" is supposed to return a list of all rows which contain '1'.

PHP Code:

$getstyles = $DB_site->query("
        SELECT *
        FROM prs_styles
        WHERE catid LIKE '$category %' OR catid LIKE '% $category %' OR catid LIKE '% $category' OR catid = $category 
        ORDER BY catid ASC
    "); 


is the fix i've ended up going for.