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').")";


From: Kevin Murphy <[EMAIL PROTECTED]>
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

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to