Re: In_Array in Query

Kevin Murphy wrote:

I'm wondering if something like this is possible, where $array is an array. $query = "select id from table where in_array(row,'$user_area')"; Is it possible to see if the value of a particular row is in an array? I know I could create a loop where it would go through each one, but I was hoping not to do something like the following: $query = "select id from table where row = $user_area[0] OR row = $user_area[1] OR row = $user_area[2]"

Not really. There is a slight shortcut: $query = "select id from table where row in (" . implode(',', $user_area) . ")"; which does much the same (your db converts it internally). That assumes 'user_area' only contains numbers, any strings in there and you'll have to create a loop so you can use the proper escaping function (depending on your db). -- Postgresql & php tutorials http://www.designmagick.com/