Advanced Search

Return to Snippet

Revision: 16073
at July 24, 2009 23:28 by iloveitaly
Initial Code 
function createIDList($idList, $dbFieldName) {
	if(count($idList) == 0) return '';
	
	$orString = '';
	
	foreach($idList as $id) {
		$orString .= "{$dbFieldName} = '{$id}' OR ";
	}
	
	return substr($orString, 0, -4);
}

// ex:
$query = "SELECT * FROM table_name WHERE ".createIDList(array(array('id_field' => 1), array('id_field' => 2)));
Initial URL 









Initial Description














Initial Title





Create SQL OR ID List









Initial Tags





database, sql, list









Initial Language





PHP