In_Array in Query

--Apple-Mail-13--252750925
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed

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]"

--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326



--Apple-Mail-13--252750925--

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/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: In_Array in Query

not as sucj, but you could consider a sub-select (providiing your version of
mysql supports it)

something like this might also work

$query = "select id from table where somefield [in|=|like] (".
in_array(row,'$user_area').")";


Bastien


>From: Kevin Murphy
>To: php-db@lists.php.net
>Subject: [PHP-DB] In_Array in Query
>Date: Tue, 22 Aug 2006 18:13:11 -0700
>
>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]"
>
>--
>Kevin Murphy
>Webmaster: Information and Marketing Services
>Western Nevada Community College
>www.wncc.edu
>775-445-3326
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php