private static function sqlWhere(&$params = null)
{
$sql = "";
$sep = "WHERE";
setIfNull($params, $_REQUEST);
//TODO: list of reserved keywords. check if params are valid columm names
unset($params["debug"]);
unset($params["table"]);
unset($params["group_by"]);
unset($params["order_by"]);
unset($params["limit"]);
$where = arrayExtract($params, "where");
foreach ($params as $key => $param) {
$sql .= " {$sep} " . SqlManager::sqlCondition($params, $key, true);
$sep = "AND";
}
if ($where) {
$sql .= " {$sep} {$where}";
}
return $sql;
}
