while (list($key, $val) = each($order)) { $DB_site->query("UPDATE smilie SET showid='$val' WHERE smilieid='$key'"); }