function getColumnsFromTable($table_name, $columns_name_array, $size = 1, $echo = false)
{
    $comma_separated = implode(",", $columns_name_array);
    $select_name = $table_name . 'Data';
    $query = "SELECT {$comma_separated} FROM `{$table_name}` WHERE " . __users_tl_expired . " IS NULL";
    $selectDropdown = "<select name=\"{$select_name}\" size=\"{$size}\">";
    $row_comma_separated = implode(", ", $columns_name_array);
    //echo $query;
    $result = mysql_query($query) or die(mysql_error());
    while ($row = mysql_fetch_array($result)) {
        $selectDropdown .= '<option>';
        $optionValue = '';
        foreach ($columns_name_array as $value) {
            $formattedValue = niceValue($value) . ': ' . $row[$value] . ', ';
            //$selectDropdown .= str_replace(" ", "&nbsp;", substr(str_pad($formattedValue, 50, " "), 0, 40)).'.';//str_pad((niceValue($value).': '.$row[$value].', '),35,".");
            $optionValue .= substr(str_pad($formattedValue, 80 - strlen($optionValue), "_"), 0, 35);
            //str_pad((niceValue($value).': '.$row[$value].', '),35,".");
        }
        $trimmedVal = trim($optionValue, " \\_\\,\t\n");
        $selectDropdown .= $trimmedVal;
        $selectDropdown .= '</option>';
    }
    $selectDropdown .= "</select>";
    if ($echo) {
        echo $selectDropdown;
    }
    return $selectDropdown;
}
 /**
  * Remove user by marking it as expired.
  */
 public function RemoveUser()
 {
     if ($_SERVER["REQUEST_METHOD"] == "POST") {
         $option_selected = test_input($_POST["usersData"]);
         echo '/' . niceValue(__users_tl_user_name) . ':.*/<br>';
         preg_match('/' . niceValue(__users_tl_user_name) . ':.*/', $option_selected, $matches);
         echo $matches[0];
         $userName = trim(substr($matches[0], 10), ',');
         echo '<br><br> user name: ' . $userName . '<br>';
         $date = date("Y-m-d");
         $removeQuery = 'UPDATE users SET `' . __users_tl_user_name . " = 'EXP_" . $userName . "', " . __users_tl_expired . "` = '" . $date . "' WHERE `" . __users_tl_user_name . "` = '" . trim($userName, ' ') . "'";
         //UPDATE `users` SET `user_name` = 'EXP_ca', `expired` = '2015-12-04' WHERE `users`.`user_name` = 'ca'
         //', '.__users_tl_user_name.'='.$expUserName.
         echo '<br><br>' . $removeQuery . '<br>';
         $removeQuery_res = mysql_query($removeQuery) or die(mysql_error());
         //_______$removeQuery_res = mysql_query($removeQuery"UPDATE users SET `expired` = 2015/12/04 WHERE `user_name` = ' nce093'") or die(mysql_error());
         if ($removeQuery_res == FALSE) {
             echo '<br><h3>FALSE </h3><br>';
         } else {
             if (mysql_errno()) {
                 echo "MySQL error " . mysql_errno() . ": " . mysql_error() . "\n<br>When executing <br>\n{$removeQuery}\n<br>";
             } else {
                 // if insert succeeded
                 echo "<script type=\"text/javascript\"> alert(\"User {$userName} was removed successfully!\"); </script>";
             }
         }
     }
 }