Friday 29 July 2011

check database for array of values.

example:UPDATE tableName SET someColumn = "updated" WHERE id IN(1, 88, 99, 152)

so it can be done by



for($i = 0; $i < count($arrayOfIDs) $i++)
{
if($i == 0)
$concatenatedIDs .= $arrayOfIDs[$i];
else
$concatenatedIDs .= ',' . $arrayOfIDs[$i];
}

$query = 'UPDATE tableName SET someColumn = "updated" WHERE id IN(' . $concatenatedIDs . ')';


No comments:

Post a Comment