[Resolved] querying with in_array type function?

[vaaaska]

ok, let's see if i can post this in the correct forum this time... 😉

i'm trying to figure out some way to perform a query using an arrray of values...similar to the usage of in_array (except not true and false)...

...WHERE (field_values = $array_values)

but aside from doing some kind of a loop with the query inside of it, i'm not sure if this can be done...

anybody have any techniques for this?

thanks...v

[mrhappiness]

$sql = 'SELECT * FROM table
WHERE yourcolumn IN '.implode(', ', $array).')';

try something like this

[vaaaska]

niiiiiiiice...

i'm fiddling with this but i can't seem to get it to work...not exactly sure whether my query would be too complex (i hope not) or what...is something not right here? without the implode in there it is working fine...fyi...

$qry = mysql_query ("SELECT * from cal,use,group
WHERE grp_id=cal_grp AND cal_ID=ID
AND cal_grp IN ' .implode(',', $arr). ');
ORDER BY cal_stamp DESC LIMIT 0,20")
or die ('Error #2a');

[mrhappiness]

change " to ' and try again

[vaaaska]

changing " to ' didn't change things...

it appears that perhaps we're missing a (...

i changed it to...

(' .implode(',', $arr). ')

aha...

(" .implode(',', $arr). ")

this does the trick...

thanks very much 😉