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 <php@xxxxxxxxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: 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
